Posts Tagged ‘sqlplus’

Configure your sql prompt

April 24, 2013 Leave a comment

To configure add the below lines to glogin.sql file in $ORACLE_HOME/sqlplus/admin

column mydbname new_value mydbname noprint
select user ||'@' || name "mydbname" from v$database ;
set sqlprompt "&&mydbname SQL> "
set termout on feedback on heading on pagesize 5000 time on timing on
set serveroutput on size 100000


Categories: Miscellaneous Tags: ,
Oracle database internals by Riyaj

Discussions about Oracle performance tuning, RAC, Oracle internal & E-business suite.


Where all the Action Is !!!!

Pavan DBA's Blog

The DBA Knowledge Store

ORACLE-BASE - Latest Articles

Where all the Action Is !!!!