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[2]: Big Whoops

RE: Re[2]: Big Whoops

From: Deshpande, Kirti <Kirti.Deshpande_at_gtedc.gte.com>
Date: Tue, 30 May 2000 14:19:15 -0500
Message-Id: <10513.107157@fatcity.com>


Alex,
Can you please post a complete and working example of what you proposed? It will be a great help..
Thanks
- Kirti

> -----Original Message-----
> From: Alex Hillman [SMTP:alex_hillman_at_physia.com]
> Sent: Tuesday, May 30, 2000 2:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re[2]: Big Whoops
>
> I think that the best way is to have a procedure which can be called from
> glogin.sql, owned by sys and grant execute to public - to get data from
> v$session and v$database. Also we can create script in SQLPATH directory
> which will call glogin.sql, so every time after entering connect
> user/password_at_alias one shoud run this script - like @c
>
> Alex Hillman
>
> -----Original Message-----
> From: Jack van Zanen [ <mailto:nlzanen1_at_ey.nl>]
> Sent: Tuesday, May 30, 2000 3:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re[2]: Big Whoops
>
>
>
>
>
> Hi
>
>
> I created a little script called "c" and placed it's location in the
> registry
> sqlpath which I call to change the connection
>
> *************
>
> accept username prompt "Type username :";
> accept password prompt "Type Password (wordt niet getoond) :" hide;
> accept sid prompt "Type instance naam (SID) :";
> connect &username/&password@&sid;
> @c:\orawin95\plus80\Glogin.sql;
> undefine username;
> undefine password;
> undefine sid;
> rem CLEAR SCREEN;
>
> ************
>
> I always use this i.s.o. connect
>
>
>
> Jack
>
>
>
>
> Ari D Kaplan <akaplan_at_interaccess.com>@fatcity.com on 05/30/2000 03:08:12
> AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
>
> Thanks Kirti for providing this in Oracle7.
>
> One problem with this is if you are already connected and issue:
>
> connect username/password_at_DB_LINK;
>
> I don't know how to get around that... if anyone out there knows how to
> refresh the prompt when you issue "connect" that would be great.
>
>
> Why are we doing this on a holiday? Well, I already had my corn on the
> cob, and the email is always on, so.....
>
> Regards,
>
> -Ari
> www.arikaplan.com
>
> On Mon, 29 May 2000, Deshpande, Kirti wrote:
>
> > Here is one way to do this in Oracle 7 that I know.. It shows the
> machine
> > name and sid name just before the SQL> prompt....
> > However, the prompt won't change for remote connections made from local
> the
> > local connection.
> >
> > set termout off
> > col myprompt noprint new_value myprompt_new
> > SELECT 'SQL> ' myprompt from dual;
> > SELECT substr(proc.program,
> > instr(proc.program,'@')+1,
> > instr(proc.program,' ') - instr(proc.program,'@')) ||
> > '[' || param.value ||
> > '] SQL> ' myprompt
> > FROM v$process proc, v$parameter param
> > WHERE param.name = 'db_name'
> > AND proc.pid = 2;
Received on Tue May 30 2000 - 14:19:15 CDT

Original text of this message

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