Customise SQL* Plus Prompt

/oracle11g/product/11.1.0/db_1/sqlplus/admin

more glogin.sql

--

-- Copyright (c) 1988, 2005, Oracle.  All Rights Reserved.

--

-- NAME

--   glogin.sql

--

-- DESCRIPTION

--   SQL*Plus global login "site profile" file

--

--   Add any SQL*Plus commands here that are to be executed when a

--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command.

--

-- USAGE

--   This script is automatically run

SET SQLPROMPT "USER'@'_CONNECT_IDENTIFIER _PRIVILEGE _DATE> "

 sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jun 14 17:16:20 2013

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

USER@REC10G AS SYSDBA 14-JUN-13>