RE: possible to set continuation prompt in sql*plus?

Roy,

You got me thinking on a tangent. How can I cut and paste the whole multi-line SQL
statement at once and have it useable. Now you can, of course, use sqlplus in silent
mode (-s), but that's a little too silent for my tastes. So how 'bout set sqlnumber off
& sqlprompt ' '. That way you get:

  select blah, deblah from blahde
  where blah != deblah and ...

Nicely cutable & pasteable, just thought I'd share.

Mike Hand

-----Original Message-----

From: Pardee, Roy E [mailto:roy.e.pardee_at_lmco.com] Sent: Tuesday, July 22, 2003 6:19 PM
To: Multiple recipients of list ORACLE-L Subject: RE: possible to set continuation prompt in sql*plus?

Apologies--I wasn't clear in my original post. Right now I'm getting:

rpardee_at_devl> select username
  2 from dba_users
  3 where username like '%MC%' ;

What I'd *really* like to have is:

rpardee_at_devl> 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:

rpardee_at_devl> select username
rpardee_at_devl> from dba_users
rpardee_at_devl> 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 Received on Wed Jul 23 2003 - 14:18:35 CDT