Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLPLUS extract binary file from table

Re: SQLPLUS extract binary file from table

From: David K. Van Zandt <dvanzandt_at_iquest.net>
Date: 1998/02/22
Message-ID: <34F02119.6139E19D@iquest.net>#1/1

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/~dvanzandt
Received on Sun Feb 22 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US