Re:RE: Re[2]: Big Whoops

Nice script. I like to SET LONG 100000 (more than 800, which is good for viewing trigger and view definitions). Also, I think there should be spaces after the ')', such as:

to_char(sysdate,'MM/DD/YY HH24:MI') d from global_name;

                                   ^

See what you mean about everyone having access to GLOBAL_NAME. I am sure that everyone has their favorite prompt and appreciate seeing what people do out there. I personally like seeing the machine name and SID in my prompt.

Take care,

-Ari

www.arikaplan.com

On Tue, 30 May 2000 dgoulet_at_vicr.com wrote:

> 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
> set arraysize 15
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue May 30 2000 - 09:45:32 CDT