Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links


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.

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!

Add your comments here.
(max 400 chars - plain text)