Path: news.easynews.com!easynews!newsfeed.frii.net!newsfeed.icl.net!lnewspeer00.lnd.ops.eu.uu.net!lnewspeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Rob" <robsinn@home.pipex.com>
Newsgroups: comp.databases.oracle.tools
References: <3ba1eca5$0$236$cc9e4d1f@news.dial.pipex.com> <tq4210rfvlnke2@news.demon.nl>
Subject: Re: SQL*Plus sqlprompt
Date: Fri, 14 Sep 2001 18:05:06 +0100
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Lines: 42
Message-ID: <3ba23935$0$225$cc9e4d1f@news.dial.pipex.com>
NNTP-Posting-Host: host-32.cbg.eng.emea.uu.net
X-Trace: 1000487221 news.dial.pipex.com 225 62.191.22.32
X-Complaints-To: abuse@uk.uu.net
Xref: easynews comp.databases.oracle.tools:44749
X-Received-Date: Fri, 14 Sep 2001 10:06:45 MST (news.easynews.com)

That works great ... thanks

Rob

Sybrand Bakker wrote in message ...
>
>"Rob" <robsinn@home.pipex.com> wrote in message
>news:3ba1eca5$0$236$cc9e4d1f@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
>
>
>