Re: Dynamic prompt in SQL*PLUS

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Tue, 24 Feb 2004 10:16:18 +0200
Message-ID: <1c9b01c3faae$7b1e1b50$73f823d5@porgand>

Yes, you can put it into glogin sql.
You don't have to set the variables yourself, sqlplus will populate these itself upon any change to username or connect string. Also, you could use another variable _DATE for having current time information in your prompt (it didn't work in my 10g beta on windows).

Tanel.

Original Message ----- From: "Prem Khanna J" <jprem_at_kssnet.co.jp> To: <oracle-l_at_freelists.org> Cc: <tanel.poder.003_at_mail.ee> Sent: Tuesday, February 24, 2004 9:59 AM Subject: RE: Dynamic prompt in SQL*PLUS

> Hi Tanel , thanx for letting me know that.
> I missed the word "dynamic" in Naveen's mail.
>
> BTW,where i do set the variables u said ?
> SET SQLPROMPT _USER'@'_CONNECT_IDENTIFIER>
>
> can i put this is in glogin.sql ?
>
> Regards,
> Prem.
>
> >>-----Original Message-----
> >>From: Tanel Poder
> >>Prem,
> >>
> >>This doesn't work "dynamicly", e.g. when you issue a connect clause to
> >>another user/connect string from inside sqlplus, then the
> >>prompt will retain
> >>the old values. But these new sqlplus variables I posted, will work
> >>dynamicly as well.
> >>
> >>Tanel.
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Feb 24 2004 - 02:13:15 CST