set up the appropriate environment

shiyihai發表於2009-03-24

1、put the following file(login.sql) into $ORACLE_HOME;
2、set environment virable:SQLPATH=$ORACLE_HOME
3、the content of file(login.sql) as follows:
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

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/38542/viewspace-1019363/,如需轉載,請註明出處,否則將追究法律責任。

相關文章