RE: SQLPLUS format question

The next best thing when spooling SQL commands is to change the SQL prompt
to a remark: sqlp 'REM ' or '-- '. For multi-line SQL set sqlcont '-- ' . Effective as
far back as I can remember.  

As in:  

SQL> set sqlp 'REM ' sqlcont '-- ' heading off feedback off REM
REM spool test.sql
REM select 'This is my dynamic SQL;' -
-- from dual;
 

This is my dynamic SQL;
REM spool off
REM set sqlp 'SQL> '
. . .
$ cat test.sql
REM select 'This is my dynamic SQL;' -
-- from dual;
 

This is my dynamic SQL;

REM spool off
$  

Regards,
Mike Hand  

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still

        Sent: Monday, August 14, 2006 7:38 PM         

        Mea Culpa: I had assumed it was being run from a file...         

	-- 
	Jared Still
	Certifiable Oracle DBA and Part Time Perl Evangelist
	

--

This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

--
http://www.freelists.org/webpage/oracle-l