Re: SQL*Plus sqlprompt
From: Rob <robsinn_at_home.pipex.com>
Date: Fri, 14 Sep 2001 18:05:06 +0100
Message-ID: <3ba23935$0$225$cc9e4d1f_at_news.dial.pipex.com>
Date: Fri, 14 Sep 2001 18:05:06 +0100
Message-ID: <3ba23935$0$225$cc9e4d1f_at_news.dial.pipex.com>
That works great ... thanks
Rob
Sybrand Bakker wrote in message ...
>
>"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 - 19:05:06 CEST