Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLPlus prompt
Hi.
This is solution for Unix machine:
in file $ORACLE_HOME/sqlplus/admin/glogin.sql put these three lines:
ho echo define sid=$ORACLE_SID>t.sql
sta t.sql
set sqlp SQL_&sid>
Regards,
Tanya
--
Tanya Injac
Oracle Developer/DBA
Unisys NZ
Sbaiz <pierluigi.sbaiz_at_elsag.it> wrote in article
<01bd7cbb$63cba160$b8cd5997_at_sbaiz>...
> Hi all
>
> I'd like to change the prompt SQL> of SQLPlus. So I want to visualize the
> prompt SQL_<istance_name> instead of SQL>.
> There's somebody that know how help me.
>
> Thanks in advance
>
> Sbaiz P.
>
>
Received on Mon May 11 1998 - 22:22:25 CDT
![]() |
![]() |