맨날 백업을 안해두어서 생각난김에..

filepath : ?/sqlplus/admin/glogin.sql

set lines 120
set pages 900
define_editor=vi

set verify off termout off head off feed off

col login_prompt new_value welcome

SELECT upper(SYS_CONTEXT('USERENV','SERVER_HOST')
||' '
|| SYS_CONTEXT('USERENV','CURRENT_USER')
||'@'
|| SYS_CONTEXT('USERENV','DB_NAME')) login_prompt
FROM DUAL
;


set sqlprompt "_user'@'_connect_identifier> "

set verify on termout on head on feed on
prompt ************************************
prompt WELCOME TO &&welcome
prompt ************************************
prompt
set echo off serveroutput on size 100000 line 100 trims on
set time on
set timing on

'6. 먹고살기 > 6.1 Oracle' 카테고리의 다른 글

COMMIT_POINT_STRENGTH  (0) 2012.01.19
11g compress table  (0) 2011.09.14
oracle user expired & lock  (0) 2011.09.09
Sqlplus, glogin.sql  (0) 2011.09.06
Tag //