Re: Environment Variables

branigan d (p0054467_at_oxford-brookes.ac.uk) wrote:
: Masud Khan (mas_at_king.ac.uk) wrote:
 

: I don't know about an environment variable you can set, but if you create
: yourself a LOGIN.SQL file with the following, which SQLPLUS will auto-execute
: you can set the SQL PROMPT to be your username automatically on starting SQLPLUS
: (for what its worth).
 

: column x new_value g
: set termout off
: select USER || '>' x from dual;
: set termout on
: set sqlprompt &g

Thanks for the info, but what I need is the user name displayed everytime I use the 'connect' command.

What doe connect consult when it is executed? is there any way of getting it to run a script which sets the user name in the prompt?

Any help will be appreciated.

Thanks

Mas

--

   ***** Please reply to the Email address below the header may be WRONG! *****

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
|                                                                               |
 #               email:      mas_at_cadence.com                                     #
|                                                                               | 
 # +------------+                                                                #
| |  |\/\/\/|  | Name:      Mas Khan  Position(s): Configuration Technician,    |
 # |  |      |  |                                   ORACLE support, Sys Admin    #
| |  |  ~  ~|  | Class:     EDC-MFG                                             |
 # |  | (o)(o)  | School:    Cadence Design Systems,                             #
| |  |     _)  |            L'avenir,                                           |
 # |  | \___|   |            Bagshot Road,                                       #
| |  |   /     |            Bracknell.                                          |
 # | /----\     | Phone:     0344-865465  Voice Mail: 1465                       #
| +------------+                                                                |
 #                                                                               #
|     -+=[ ]=+- All opinions expressed are mine and mine only -+=[ ]=+-         |
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#