SET ROWLIMIT in Oracle 18c

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

SET ROWLIMIT {n | 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.

Example

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

SQL> SET ROWLIMIT 10;
SQL>
SQL> show ROWLIMIT;
rowlimit 10
SQL>
SQL> select table_name from dba_tables;

TABLE_NAME
-------------------------
ICOL$
COL$
IND$
TAB$
CLU$
LOB$
COLTYPE$
SUBCOLTYPE$
NTAB$
REFCON$

10 rows selected. (rowlimit reached)

SQL>

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: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp