/**PageBeginHtml Block Begin **/ /***自定义返回顶部小火箭***/ /*生成博客目录的JS 开始*/ /*生成博客目录的JS 结束*/

修改 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>





---------

posted @ 2017-12-10 19:30  一品堂.技术学习笔记  阅读(504)  评论(0编辑  收藏  举报