Re: Re[2]:RE: Re[2]: Big Whoops

Sorry about top posting, this is a laptop with MS.

Do not forget TWO_TASK, otherwise you may make a fatal error.

Regards.

--
S. Anthony Sequeira

Wait for the ricochet

Opinions expressed herein are my own and do
not necessarily represent those of my employer
----- Original Message -----
From: <dgoulet_at_vicr.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: 30 May 2000 20:52
Subject: Re[2]:RE: Re[2]: Big Whoops




> At the Unix level I like that too.  If your on HP-UX try setting:

>

>     export PS1=`hostname`:\$PWD:\$ORACLE_SID>

>

>

> ____________________Reply Separator____________________

> Author: Ari D Kaplan <akaplan_at_interaccess.com>

> Date:       5/30/00 7:56 AM

>

> 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).

> >

>

> --

> Author: Ari D Kaplan

>   INET: akaplan_at_interaccess.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).

> --

> 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