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

Comments

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...

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...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired