Re: SQL Plus and the SQL prompt...

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 6 Sep 2000 16:09:35 +0100
Message-ID: <8p5mnh$9sl$1@soap.pipex.net>

No , but you could duplicate this by creating a script conn.sql and/or a script connect.sql which call the same routine and accept connect descriptions as parameters.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"George Leonard" <george_at_is.co.za> wrote in message
news:39b5da5e$0$235_at_hades.is.co.za...


> This is great except the file only gets read when you open sqlplus.

>

> could it be changed so that once you have opened and connect and you then

> connect to another machine that is refreshes itself automatically.

>

> thx

>

>

> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message

> news:968178007.2385.0.pluto.d4ee154e_at_news.demon.nl...

> > easy

> > column global_name new_value dbnam

> > select global_name from global_name;

> > set sqlprompt &dbnam.>

> >

> > Hth,

> >

> > Sybrand Bakker, Oracle DBA

> >

> >

> > "Sean" <dolans_at_my-deja.com> wrote in message

> > news:8p38m5$tms$1_at_nnrp1.deja.com...

> > > Oracle 8i on Windows Nt, connecting to it via SQL PLUS.

> > >

> > > Is it possible to have the prompt be something else besides "SQL>" ?

> > > For example, the name of the instance of the machine you are

 connecting


> > > to?  If so, any directions would be greatly appreciated.

> > >

> > > Thanks,

> > > Sean

> > >

> > >

> > > Sent via Deja.com http://www.deja.com/

> > > Before you buy.

> >

> >

>

>

Received on Wed Sep 06 2000 - 10:09:35 CDT