RE: SQL*Plus startup commands

From: Thalis Kalfigopoulos <t.kalfigopoulos_at_alumil.com>
Date: Wed, 11 Aug 2004 14:17:38 +0300
Message-ID: <ONEEIIPGMICHDHGFMDJOGEBACAAA.t.kalfigopoulos@alumil.com>

> 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_at_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_at_alumil.com
Tel: +30 23410 79300

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Aug 11 2004 - 06:10:18 CDT