1Last Login:thu Dec 8 19:18:08 from 192.168.242.12[Email protected] ~]# su-oracle3[Email protected] ~]$ CD $ORACLE _home4[Email protected] db_1]$ CD sqlplus/5[Email protected] sqlplus]$ CD admin/6[email protected] admin]$ cat Glogin.sql7 --8 --Copyright (c) 1988, Oracle and/or its affiliates.9 --All rights reserved.Ten -- One --NAME A --Glogin.sql - -- - --DESCRIPTION the --Sql*plus Global Login "site profile" file - -- - --Add any sql*plus commands here so is executed when a - --User starts Sql*plus, or uses the Sql*plus CONNECT command. + -- - --USAGE + --This script is automatically run A -- at[Email protected] admin]$ VI glogin.sql - - - - - in - to -- + --Copyright (c) 1988, Oracle and/or its affiliates. - --All rights reserved. the -- * --NAME $ --Glogin.sqlPanax Notoginseng -- - --DESCRIPTION the --Sql*plus Global Login "site profile" file + -- A --Add any sql*plus commands here so is executed when a the --User starts Sql*plus, or uses the Sql*plus CONNECT command. + -- - --USAGE $ --This script is automatically run $ -- - - the -Set Sqlprompt "_user ' @ ' _connect_identifier>"Wuyi~ the~ -~ Wu~ -~ About~ $~ -~ -~ -"Glogin.sql"20L, 417C written A[Email protected] admin]$ Sqlplus/as sysdba; + theSql*plus:release 11.2.0.3.0 Production on Thu Dec 8 20:49:31 2016 - $Copyright (c) 1982, Oracle. All rights reserved. the the theConnected to: theOracle Database 11g Enterprise Edition Release 11.2.0.3.0-production -With the partitioning, OLAP, Data Mining and Real application testing options in the[Email protected]>
---------
Modify the SQL prompt information: