Assigning the SQL PROMPT
From: <TRBER2_at_CPVMA.sr.chevron.com>
Date: Tue, 7 Mar 1995 06:42:42 GMT
Message-ID: <1735913F62S86.TRBER2_at_CPVMA.sr.chevron.com>
Date: Tue, 7 Mar 1995 06:42:42 GMT
Message-ID: <1735913F62S86.TRBER2_at_CPVMA.sr.chevron.com>
Is there a way to dynamically set the SQL PROMPT in SQL PLUS depending on which line of my CONFIG.ORA is active. I continuously work on several db's during the day and it would be helpful to have my prompt say something other than SQL>. I prefer to not have several different LOGIN.SQL's each with a different SET SQLPROMPT command. Thanks in advance. Received on Tue Mar 07 1995 - 07:42:42 CET