SQL*Plus startup commands

From: Thalis Kalfigopoulos <t.kalfigopoulos_at_alumil.com>
Date: Wed, 11 Aug 2004 13:22:32 +0300
Message-ID: <ONEEIIPGMICHDHGFMDJOIEANCAAA.t.kalfigopoulos@alumil.com>

Hi all,
I'm extremely new to Oracle. Haven't seen novice questions here so far but I'll take my chances. I read in http://www.orafaq.net/kb/link.php?id=271 about things that can be placed in login.sql for SQL*Plus's startup. I try the sample code which is for 10g:
set sqlprompt "&&_USER@&&_CONNECT_IDENTIFIER SQL>"

The _CONNECT_IDENTIFIER is correctly bound to the db I connect to, but I need to supply the username each time I login, to build _USER. Isn't there a variable that holds the username I used as soon as I successfully login, which I can use to build my sqlprompt?

I'm using Release 9.2.0.1.0

TIA.

---

Thalis Kalfigopoulos
IT Department
Alumil S.A.
Kilkis Industrial Area
61100, Greece
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 - 05:15:23 CDT