You are awesome Tanel! >-----Original Message----- >From: Tanel Põder [mailto:tanel.poder.003@xxxxxxx] >Sent: Tuesday, February 24, 2004 12:54 PM >To: oracle-l@xxxxxxxxxxxxx >Subject: Re: Dynamic prompt in SQL*PLUS > > >Hi! > >In 10g you can use _USER and _CONNECT_IDENTIFIER sqlplus variables, for >example: > >SET SQLPROMPT _USER'@'_CONNECT_IDENTIFIER> > >Before 10g you can't have dynamic prompt inside sqlplus. > >Tanel. > >----- Original Message ----- >From: "Naveen, Nahata (IE10)" <Naveen.Nahata@xxxxxxxxxxxxx> >To: <oracle-l@xxxxxxxxxxxxx> >Sent: Tuesday, February 24, 2004 9:14 AM >Subject: Dynamic prompt in SQL*PLUS > > >> Hi All, >> >> A simple SQL*PLUS question. How to get a dynamic prompt in SQL*PLUS? >> >> I have put the code to set prompt as "Username@Db_name SQL>" >in login.sql, >> the prompt is stationary. It doesn't change if I connect as >a different >> user. How to make it dynamic? >> >> Regards, >> Naveen Nahata >> |=====================================| >> | Honeywell Technology Solutions Labs | >> | 151/1, Doraisanipalya, | >> | Bannerghatta Road, | >> | Bangalore - 560 076 | >> | Phone: 6588360, 51197222 | >> | Fax : 6584750, 51109907 | >> | Email: naveen.nahata@xxxxxxxxxxxxx | >> |=====================================| >> >> Winning is not everything, >> It's the only thing!!! >> >> ---------------------------------------------------------------- >> 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 >----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------