RE: SQL*Plus startup commands
- From: "Thalis Kalfigopoulos" <t.kalfigopoulos@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Aug 2004 14:17:38 +0300
> It was an excellent newbie question as well. you told us what you
> wanted to do, the steps that you'd gone through to get there and your
> version information. This is rare when asking technical questions.
Took me a whole 10' to write ;-)
> Unless you have any old databases to connect to (like prior to 8174)
> I'd suggest you consider getting the 10g client just for the
> enhancements to sqlplus alone.
That would be nice, but wouldn't there be any side-effects? For you to suggest
it, I presume no.
So now the obvious question: how do I get the "10g client"? Need to have the
10g CDs?
What sort of enhancements are we talking about anyway?
TIA again.
ps. Just for the record, the solution I've settled with for setting the
SQLPROMPT as USER@CONNECTION is:
define myprompt="not connected>"
column myprompt new_value myprompt
set termout off
select lower(user) || '@' || lower(substr(global_name, 1, instr(global_name,
'.')-1)) myprompt from global_name;
set termout on
set sqlprompt '&&myprompt> '
______________________________
Thalis Kalfigopoulos
IT Department
Alumil S.A.
Kilkis Industrial Area
61100, Greece
E-mail: t.kalfigopoulos@xxxxxxxxxx
Tel: +30 23410 79300
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
