Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLPLUS extract binary file from table
Unless there's more to this than you're saying, think about what you asking. The "WP files" are propriatary-formatted, or IOW the formatting, style sheet info is stored with the text -- therefore, any "simple query", either in SQL or at an O/S command prompt, will show binary cod.
As far as storing the LONG column into a table, check out your SPOOL commands.
Dwight Long wrote:
>
> I have an application that stores WordPerfect files in an oracle table
> field. How can I pull these files out of oracle to a file using
> SQLPLUS? A simple query of the field shows only a few strange
> characters and 'WP'
>
> any help greatly appreciated.
-- Dave Van Zandt (work) (changing) (pers) dvanzandt@iquest.net http://members.iquest.net/~dvanzandtReceived on Sun Feb 22 1998 - 00:00:00 CST
![]() |
![]() |