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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Plus and the SQL prompt...

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

Original text of this message

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