Yes, what I meant is that the continuation prompt will be identical to the first line prompt - meaning that there is no SEPARATE continuation prompt.
> -----Original Message-----
> From: Arup Nanda [mailto:orarup_at_hotmail.com]
> Sent: mardi, 22. juillet 2003 14:25
> To: Multiple recipients of list ORACLE-L
> Subject: Re: possible to set continuation prompt in sql*plus?
>
>
> Setting SQLNUMBER OFF will make the SQLPROMPT continuation prompt, not
> completely eliminate it.
>
> Isn't it what the OP wanted in the first place?
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, July 22, 2003 3:59 PM
>
>
> > sqlcontinue changes the prompt for the continuation of a
> SQL*Plus command,
> not a SQL command.
> > sqlnumber off will mean that instead of having number prompts on the
> continuation of a SQL statement the SQL prompt will be
> continued (which I
> personally find annoying).
> >
> > set sqlnumber off should eliminate the problem of the
> "indented first
> line", but you won't get a continuation prompt at all.
> >
> > Example (using SQL*Plus 8.1.7):
> > SQL> -- continuation of a SQL*Plus command.
> > SQL> prompt -
> > > Hello World
> > Hello World
> > SQL> set sqlcontinue "Next> "
> > SQL> prompt -
> > Next> Hello World
> > Hello World
> > SQL> -- +++++++++++++++++++++++++++++++++++++++
> > SQL> -- continuation of a SQL command
> > SQL> select *
> > 2 from dual where 1 = 2 ;
> > aucune ligne sélectionnée
> > SQL> set sqlnumber off
> > SQL> select *
> > SQL> from dual where 1 = 2 ;
> > aucune ligne sélectionnée
> >
> >
> > > -----Original Message-----
> > > From: Arup Nanda [mailto:orarup_at_hotmail.com]
> > > Sent: mardi, 22. juillet 2003 12:44
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: possible to set continuation prompt in sql*plus?
> > >
> > >
> > > I suggested using SET SQLNUMBER OFF. This sure works in
> > > SQL*Plus 8i and
> > > above; not sure if it does in 8.0.6 and I don't have a test
> > > executable to
> > > test it. But have you tried it?
> > >
> > > Arup Nanda
> > > ----- Original Message -----
> > >
> > > > That's right--I am looking for an analogue to PS<x>. I've
> > > been playing
> > > around w/sqlcontinue & sqlnumber but so far no joy. I'm
> > > using sql*plus
> > > 8.0.6.0.0 (running against an 8.1.6 db).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jacques Kilchoer
> > INET: Jacques.Kilchoer_at_quest.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arup Nanda
> INET: orarup_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Jul 22 2003 - 16:06:44 CDT
