8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Row Limiting Clause for Top-N Queries in Oracle Database 12c Release 1 (12.1)


Paul Moore said...

One thing not covered here, which occurred to me when thinking about using offset to page through a dataset, is whether the offset/rowcount values can be bind variables. The documentation soesn't seem to say anything on the subject.

Tim... said...

Hi.

Yes, they can be. The feature would be pretty useless if they couldn't. :)

I've mentioned it, with an example, at the bottom of the paging section.

Cheers

Tim...

Abc said...

Very good content in this Site

Jitendra Patel said...


One thing not covered here, which occurred to me when thinking about using offset to page through a dataset, is whether the offset/rowcount values can be bind variables. The documentation doesn't seem to say anything on the subject.

Tim... said...

Hi.

You didn't read very far then. That is covered in this article...

Cheers

Tim...

Fabio Pan said...

Good content.
There is any advantage regarding performance?

Tim... said...

Hi.

No. You can see from the query transformation, this is just syntax candy to make thing easier to code. There are no performance gains.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.