8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | 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...


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.



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!