Re: SQLPLUS format question

Hi :

   I would suggest you use a free tool to extract oracle rows as flat text file.

   http://www.iamdba.com/ociuldr.html

On 8/15/06, Hand, Michael T <HANDM_at_polaroid.com> wrote:
>
> 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.
>
>

-- 
Welcome!
Home: http://www.IamDBA.com

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