Re: Dynamic prompt in SQL*PLUS
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Feb 2004 10:16:18 +0200
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@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Cc: <tanel.poder.003@xxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
