Display the SQL_ID for each SQL statement using SET FEEDBACK ON SQL_ID option.
SET FEEDBACK ON SQL_ID feature is used to display the SQL_ID for each SQL statement.
This feature will provide the SQL_ID on the end of our executed SQL Statement.
Set the number of rows displayed for particular SQL statement using SET ROWLIMIT option.
SET ROWLIMIT feature is used to set the limit for number of rows displayed for each SQL statement.
By default, ROWLIMIT is OFF.
Dynamically change the output display to fit the screen size using SET LINESIZE option.
The SET LINESIZE feature is a WINDOW option. Automatically it will be change the linesize and pagesize for the given output based on width and height of the screen size.
Catch Me On:- Hariprasath Rajaram
LinkedIn: https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook: https://www.facebook.com/HariPrasathdba
FB Group: https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
