修改 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>
---------
为人:谦逊、激情、博学、审问、慎思、明辨、 笃行
学问:纸上得来终觉浅,绝知此事要躬行
为事:工欲善其事,必先利其器。
态度:道阻且长,行则将至;行而不辍,未来可期
.....................................................................
------- 桃之夭夭,灼灼其华。之子于归,宜其室家。 ---------------
------- 桃之夭夭,有蕡其实。之子于归,宜其家室。 ---------------
------- 桃之夭夭,其叶蓁蓁。之子于归,宜其家人。 ---------------
=====================================================================
* 博客文章部分截图及内容来自于学习的书本及相应培训课程以及网络其他博客,仅做学习讨论之用,不做商业用途。
* 如有侵权,马上联系我,我立马删除对应链接。 * @author Alan -liu * @Email no008@foxmail.com
转载请标注出处! ✧*꧁一品堂.技术学习笔记꧂*✧. ---> https://www.cnblogs.com/ios9/
学问:纸上得来终觉浅,绝知此事要躬行
为事:工欲善其事,必先利其器。
态度:道阻且长,行则将至;行而不辍,未来可期
.....................................................................
------- 桃之夭夭,灼灼其华。之子于归,宜其室家。 ---------------
------- 桃之夭夭,有蕡其实。之子于归,宜其家室。 ---------------
------- 桃之夭夭,其叶蓁蓁。之子于归,宜其家人。 ---------------
=====================================================================
* 博客文章部分截图及内容来自于学习的书本及相应培训课程以及网络其他博客,仅做学习讨论之用,不做商业用途。
* 如有侵权,马上联系我,我立马删除对应链接。 * @author Alan -liu * @Email no008@foxmail.com
转载请标注出处! ✧*꧁一品堂.技术学习笔记꧂*✧. ---> https://www.cnblogs.com/ios9/