|Row Limiting Clause for Top-N Queries in Oracle Database 12c Release 1 (12.1) - Simplify the syntax of Top-N queries using the row limiting clause of Oracle Database 12c.|
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.
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.