I want to share here the
sqlplus tips i found in my daily life activities. I will keep this post open to
share those tips and i will do my best to update this thread regularly.
Tips:
1-Replace the SQL> Prompt
with the Current User Name
we can do this by using set
sqlprompt '_user> '
Example:
oracle@svtim02:[BSCSUAT] $ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Aug 4 14:54:31
2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
SQL> set sqlprompt '_user> '
SYS>
SYS>
