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 […]

Read More