设置SQL*Plus的登录配置

--设置SQL*Plus的登录配置

[oracle@ocm1 ~]$ ls /u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/glogin.sql 
/u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/glogin.sql
[oracle@ocm1 ~]$ cat !$
cat /u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/glogin.sql
--
-- Copyright (c) 1988, 2011, Oracle and/or its affiliates. 
-- All rights reserved. 
--
-- NAME
--   glogin.sql
--
-- DESCRIPTION
--   SQL*Plus global login "site profile" file
--
--   Add any SQL*Plus commands here that are to be executed when a
--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
--
-- USAGE
--   This script is automatically run
--
define _editor=vi  --设置编辑器为vi
set serveroutput on size 1000000  --显示用DBMS_OUTPUT.PUT_LINE进行输出的信息
set trimspool on  --把输出内容每行后面多余的空格去掉
set long 5000	--设置显示LONG的字节数
set linesize 100  --设置一行可以容纳的字符数
set pagesize 9999  --设置一页的行数
column plan_plus_exp format a80 --设置列的长度
set sqlprompt '&_user.@&_connect_identifier.> '  --设置显示当前库名与用户名