I currenty have a script saved in my sql directory
prompt Note - you are logged on as DPS
set linesize 1000
set pagesize 40
set sqlp 'DPSdatabase> '
set serveroutput on
set trims on
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
In the icon I have setup in desktop I have the command line pointing to this sql script.
The issue is that whilst in my sqlplus session with my prompt as
if I choose to connect to another database, my prompt remains as DPSdatabase>
How can I get around this???
Click Here to Expand Forum to Full Width