Re: SQL*Plus sqlprompt
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 14 Sep 2001 15:35:20 +0200
Message-ID: <tq4210rfvlnke2_at_news.demon.nl>
Date: Fri, 14 Sep 2001 15:35:20 +0200
Message-ID: <tq4210rfvlnke2_at_news.demon.nl>
[Quoted] "Rob" <robsinn_at_home.pipex.com> wrote in message
news:3ba1eca5$0$236$cc9e4d1f_at_news.dial.pipex.com...
> Hi
>
> Can I amend the login.sql file to set the 'sqlprompt' value to show who
I'm
> logged in as ?
>
> i.e. If I connect as 'scott', I'd like the sqlprompt to be 'scott>'
>
> Thanks ...
>
> Rob Sinn
> Cambridge, UK
>
>
>
>
column user new_value unam
set termout off
select user
from dual
/
set termout on
set sqlprompt "&unam..>"
Hth,
Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 14 2001 - 15:35:20 CEST