Re: SQLPROMPT in Sql*Plus
From: shobs <member38226_at_dbforums.com>
Date: Fri, 05 Sep 2003 03:19:05 -0400
Message-ID: <3333654.1062746345_at_dbforums.com>
Date: Fri, 05 Sep 2003 03:19:05 -0400
Message-ID: <3333654.1062746345_at_dbforums.com>
Hi,
If you want the global db name in the sql prompt
put this line in the glogin.sql (affects all users) or login.sql(for the user):
SET SQLPROMPT '&_CONNECT_IDENTIFIER:SQL>' If you want to pass any value as the dbname just put:
SET SQLPROMPT '&_DB NAME>' When you login to sqlplus this will prompt for the db_name.
Hope this helps
-- Posted via http://dbforums.comReceived on Fri Sep 05 2003 - 09:19:05 CEST