Sets a limit for the number of rows to display for a query. By default, ROWLIMIT is OFF.


  • n can be any number between 1 and 2,000,000,000. An error is displayed when the value that is entered is outside this range.
  • OFF displays all the rows in the output.


To set the number of rows to display as 10, enter:

Stay tuned for more articles on Oracle 18c 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.