vsbabu.org

Useful SQL*Plus headers

So who knows, it might be worth noting down!

• SET FEEDBACK ON - show records that got affected
• SET TERMOUT ON - show terminal output
• SET ECHO ON - display the command that is about to be run
• SET TIMING ON - print the time taken for each command to run
• SET VERIFY ON - show variable substitutions

Additionally, you might want to put the following in login.sql to ensure you are connected to the right schema.

SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER > "