Re: Change the prompt in SQL*PLUS

Hi,

To suppress the old and new values, you may use : SET VERIFY OFF Thanks

Chandra

tedchyn_at_yahoo.com wrote:

> Bruno, the customization of prompt can be made in login.sql, so
> everytime you would see the customized prompt. But when you conn to
> another instance from the prompt - the prompt does not change.
>
> Ted
> In article <7jqfqn$7m0$1_at_feed.teaser.fr>,
> "Bruno Thomas" <bruno.nospam_at_teaser.fr> wrote:
> > <agi_at_mail.taicom.com.tw> a écrit dans le message :
> > 7jprqd$3hc$1_at_nnrp1.deja.com...
> > > Hi, theres ,
> > > I have two problems:
> > > 1.How do I write a script to change the prompt in SQL*PLUS like
> > > follows :
> > >
> > > sessionid,ser#_at_dbname> instead of just SQL>
> > >
> >
> > Here a script to have username_at_global_name :
> >
> > set termout off
> > set pause off
> > define new_prompt='nolog'
> > column value new_value new_prompt
> > select username || '_at_' || global_name value from user_users,
> global_name;
> > set sqlprompt "&new_prompt> "
> > set termout on
> >
> > you have only to adapt the query to obtain serial# and sessionid.
> >
> > >
> > > 2.How can I run a sql script (lets say xxx.sql) without the
> > > old ....new two lines
> > >
> > > SQL> _at_xxx cust
> > > old 2: where table_Name = UPPER('&1')
> > > new 2: where table_Name = UPPER('cust')
> > >
> > > Just see the query result.
> >
> > SHOW[MODE] {OFF|ON}
> >
> > Controls whether SQL*Plus lists the old and new settings of a SQL*Plus
> > system variable when you change the setting with SET. ON lists the
> settings;
> > OFF suppresses the listing. SHOWMODE ON has the same behavior as the
> > obsolete SHOWMODE BOTH.
> >
> > > Rgds,
> > > Agi Chen
> >
> > Hope this help...
> >
> > --
> > Bruno Thomas
> > bruno.nospam_at_teaser.fr est ma véritable adresse
> > bruno.nospam_at_teaser.fr is my real address
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jun 11 1999 - 17:52:55 CEST