Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Re[2]: Big Whoops
Ari,
Try this as your login.sql. Everyone has access here.
set numwidth 10
set pagesize 24
set linesize 79
set pause 'Press ENTER/Return for more .....>'
set copycommit 5
set long 800
column text format A70 word
define _editor=edit
column d format A15
set arraysize 1
break on name on user
column gname new_value _name noprint
column user new_value _user noprint
column d heading 'Current date/time' format A18
select substr(global_name,1,instr(global_name,'.')-1)gname,user,
to_char(sysdate,'MM/DD/YY HH24:MI')d from global_name;
set sqlprompt "&_name:&_user> "
clear breaks
clear column
Received on Tue May 30 2000 - 08:06:51 CDT
![]() |
![]() |