Set SQLPROMPT - Customizing SQL Prompt
----------------------------------------------------------
SQL Prompt With Time
----------------------------------------------------------
SQL> set time on
09:50:16 SQL>
09:50:19 SQL> select sysdate from dual;

SYSDATE
---------
31-SEP-12

09:50:34 SQL>

----------------------------------------------------------
SQL Prompt With USER
----------------------------------------------------------
SQL> set sqlprompt "_USER> "
SCOTT>
SCOTT>
SCOTT> select sysdate from dual;

SYSDATE
---------
31-SEP-12

SCOTT>


----------------------------------------------------------
SQL Prompt With SID
----------------------------------------------------------
SQL> set sqlprompt "_CONNECT_IDENTIFIER> "
mydb>
mydb>
mydb> select sysdae from dual;

SYSDATE
---------
31-SEP-12

mydb>

----------------------------------------------------------
SQL Prompt With USER@SID
----------------------------------------------------------
SQL> set sqlprompt "_USER'@'_CONNECT_IDENTIFIER SQL> "
SCOTT@mydb SQL>
SCOTT@mydb SQL>
SCOTT@mydb SQL> select sysdate from dual;

SYSDATE
---------
31-SEP-12

SCOTT@mydb SQL>


----------------------------------------------------------
SQL Prompt With DATE
----------------------------------------------------------
SQL> set sqlprompt "_DATE SQL> "
31-SEP-12 SQL>
31-SEP-12 SQL>
31-SEP-12 SQL> select sysdate from dual;

SYSDATE
---------
31-SEP-12

31-SEP-12 SQL>

----------------------------------------------------------
SQL Prompt With Custom String
----------------------------------------------------------
SQL> set sqlprompt "Hello World> "
Hello World>
Hello World>
Hello World> select sysdate from dual;

SYSDATE
---------
31-SEP-12