Configure SQL*PROMPT

Configure SQL*PROMPT with user name and database name


Just edit GLOGIN.SQL file
Located: $ORACLE_HOME/sqlplus/glogin.sql


open glogin.sql file add set sqlprompt ORCL@TAJ>
replace ORCL and TAJ with your database name and user name

C:\>sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Wed May 2 20:19:59 2007

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> --update glogin.sql file
SQL> exit

C:\>sqlplus/nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Wed May 2 20:20:25 2007

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ORCL@TAJ>