SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to extract in CSV format BLOB without spooling ?

CHU TOULOUSEDec 19 2017 — edited Dec 21 2017

Hello folks;

I'm under Oracle 11204.

I have to extract, in delimiter format, the result of an SQL statement.

But In this SQL statement I have BLOB (nullable) field so I can't do a spool (because it's limited by the "lines" parameter).

Please help me.

Regards.

A.D

This post has been answered by Paulzip on Dec 20 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2018

Added on Dec 19 2017

25 comments

6,022 views