Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Re[2]: Big Whoops

Re:RE: Re[2]: Big Whoops

From: <dgoulet_at_vicr.com>
Date: Tue, 30 May 2000 09:06:51 -0400
Message-Id: <10513.107089@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US