| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: possible to set continuation prompt in sql*plus?
set sqlprompt "^G"
Will make it less quiet.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com
-----Original Message-----
From: Hand, Michael T [mailto:HANDM_at_polaroid.com]
Sent: Wednesday, July 23, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject: 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-----
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:
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
SWFPAC Lockheed Martin IT
Extension 8487
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hand, Michael T
INET: HANDM_at_polaroid.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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 Wed Jul 23 2003 - 15:03:48 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |