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-----
Sent: Tuesday, July 22, 2003 6:19 PM
To: Multiple recipients of list ORACLE-L
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hand, Michael T
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).
