修改 sql 提示符信息:

  1 Last login: Thu Dec  8 19:18:08 2016 from 192.168.242.1
2 [root@localhost ~]# su - oracle
3 [oracle@localhost ~]$ cd $ORACLE_HOME
4 [oracle@localhost db_1]$ cd sqlplus/
5 [oracle@localhost sqlplus]$ cd admin/
6 [oracle@localhost admin]$ cat glogin.sql
7 --
8 -- Copyright (c) 1988, 2011, Oracle and/or its affiliates.
9 -- All rights reserved.
10 --
11 -- NAME
12 -- glogin.sql
13 --
14 -- DESCRIPTION
15 -- SQL*Plus global login "site profile" file
16 --
17 -- Add any SQL*Plus commands here that are to be executed when a
18 -- user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
19 --
20 -- USAGE
21 -- This script is automatically run
22 --
23 [oracle@localhost admin]$ vi glogin.sql
24
25
26
27
28
29
30
31 --
32 -- Copyright (c) 1988, 2011, Oracle and/or its affiliates.
33 -- All rights reserved.
34 --
35 -- NAME
36 -- glogin.sql
37 --
38 -- DESCRIPTION
39 -- SQL*Plus global login "site profile" file
40 --
41 -- Add any SQL*Plus commands here that are to be executed when a
42 -- user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
43 --
44 -- USAGE
45 -- This script is automatically run
46 --
47
48
49
50 set sqlprompt "_user'@'_connect_identifier> "
51 ~
52 ~
53 ~
54 ~
55 ~
56 ~
57 ~
58 ~
59 ~
60 "glogin.sql" 20L, 417C written
61 [oracle@localhost admin]$ sqlplus / as sysdba;
62
63 SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 8 20:49:31 2016
64
65 Copyright (c) 1982, 2011, Oracle. All rights reserved.
66
67
68 Connected to:
69 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
70 With the Partitioning, OLAP, Data Mining and Real Application Testing options
71
72 SYS@orcl>

---------

上一篇:Leetcode480-Sliding Window Median


下一篇:javascript运动系列第七篇——鼠标跟随运动