Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLPlus prompt

Re: SQLPlus prompt

From: Tanya Injac <tanyainjac_at_unn.unisys.com>
Date: 12 May 1998 03:22:25 GMT
Message-ID: <01bd7d55$30303600$6762df81@nz6220.nz.unisys.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US