« »

Substitute of LIMIT clause (as used in MySQL) in O…

Tuesday, 3 July 2007, 18:46 | Category : Database, Technology
Tags :

Substitute of LIMIT clause (as used in MySQL) in Oracle:

SELECT COL_NAME (SELECT COL_NAME, ROWNUM r from TABLE_NAME) WHERE r BETWEEN 10 AND 15

It will select 6 rows (10th to 15th inclusive)

Related posts:

  1. Selecting random rows from an oracle table
  2. How to drop everything on a oracle schema
  3. How to send email from oracle stored procedure