当前位置： 移动技术网 > IT编程>数据库>MSSQL > sqlplus登录环境设置

sqlplus登录环境设置

2018年04月09日  | 移动技术网IT编程  | 我要评论

种桑误国,锡膏自动添加装置,广漠的近义词

通过glogin.sql文件设置sqlplus登录的环境设置

 

编辑$ORACLE_HOME/sqlplus/admin下的glogin文件

 

详细内容如下所示：

define_editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
define gname=idle
column global_name new_value gname
select lower(user) || '@' || substr(global_name,1,decode( dot,0,length(global_name),dot-1) ) global_name from (select global_name,instr(global_name,'.') dot from global_name );
set sqlprompt '&gname> '
set termout on

 

 

保存之后使用sqlplus登录查看设置后的效果

 

[oracle@rac1 ~]$ sqlplus system/oracle

SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 7 15:11:45 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

system@RACDB>

 

 

使用sys登录

 

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 7 15:12:27 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

sys@RACDB>

 


您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网