Apologies--I wasn't clear in my original post. Right now I'm getting:
[EMAIL PROTECTED]> select username
2 from dba_users
3 where username like '%MC%' ;
What I'd *really* like to have is:
[EMAIL PROTECTED]> select username
2 from dba_users
3 where username like '%MC%' ;
That way I could copy/paste sql commands as easily as I could when my prompt was just
"SQL> ".
Setting sqlnumber off gets me:
[EMAIL PROTECTED]> select username
[EMAIL PROTECTED]> from dba_users
[EMAIL PROTECTED]> where username like '%MC%' ;
Which isn't horrible, although I do miss the numbers. But no matter--I'll just live
with it...
Many thanks!
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
Sent: Tuesday, July 22, 2003 2:25 PM
To: Multiple recipients of list ORACLE-L
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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Pardee, Roy E
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
