This is a short blog about new features introduced in Oracle 18c sqlplus ….that could be helpful for you !
The objective of this command is to display certain number of rows, especially with large tables
In the below example the COUNTRIES table has 25 records, when I set ROWLIMIT to 3 , only three rows will be displayed when querying the table (the first 3 rows)
The below command will display the current setting:
SET FEEDBACK ON SQL_ID
This command will return the sql_id for the SQL or PL/SQL statements that is currently being executed. This will consequently help in debugging activities.
As shown below the executed query will generate the SQL_ID with the query result:
You can check it from v$sql by executing:
SQL> SELECT sql_text,sql_id FROM v$sql WHERE sql_id = ‘agjjdvhgdzd1q’;