Re: Environment Variables

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

   Damian Branigan
   (Project Leader ISS)

   d.branigan_at_brookes.ac.uk        "So free we seem, so fettered fast we are."
                                    RB


_______________________________________________________________________________