Re: sqlplus prompt

I don't know about the database name (i.e. sales or people) but here's how to get the userid in the prompt:

in your login.sql add these lines:

column userid noprint new_value myname
select user userid from dual;
set sqlprompt &&myname>

this will give you user and > for an sqlplus prompt.

HTH
janet

Hans wrote:
>
> For sql*plus i would like to use a login.sql that
> changes the prompt. When i connect like:
> connect scott/tiger_at_sales
> The sqlplus prompt would be:
> scott_at_sales>
> When i start another sqlplus session like:
> connect system/manager_at_people
> The prompt would be:
> system_at_people>
  Received on Mon Dec 16 1996 - 00:00:00 CST