Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SET command variables across sessions

SET command variables across sessions

From: jr <webmaster_at_127.0.0.1>
Date: Thu, 09 Nov 2000 17:45:06 +0000
Message-ID: <3A0AE2A2.815EE177@127.0.0.1>

Hi,

when setting SET command variables (e.g. SET SQLPROMPT "MY_PROMPT") from the sqlplus command line I loose this information when I exit sqlplus. Is there a way to keep my SET settings across sessions?

One idea would be to replace the sqlplus binary with a script that starts the original sqlplus and calls a sql script to set these environment variables.

Any other ideas?
Thanks,
jr Received on Thu Nov 09 2000 - 11:45:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US