Oracle 18c sqlplus new features

This is a short blog about new features introduced in Oracle 18c sqlplus ….that could be helpful for you !

SET ROWLIMIT

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)

Picture1

The below command will display the current setting:

Picture2

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:

Picture3

You can check it from v$sql by executing:

SQL> SELECT sql_text,sql_id FROM v$sql WHERE sql_id = ‘agjjdvhgdzd1q’;

Picture4

 

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s