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: Store large Word or PDF file in DB

Re: Store large Word or PDF file in DB

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 14 Jan 2002 08:38:01 -0000
Message-ID: <3c4298ea$0$234$ed9e5944@reading.news.pipex.net>


look into the BLOB datatype (8i and above). You can either store the data directly or as a BFILE (external file reference).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"cschang" <cschang_at_maxinter.net> wrote in message
news:3C426609.20709_at_maxinter.net...

> Is it possible to storage a very larg word file ( more than 4K
> charcaters) or even PDF type file into database? So I can use some kind
> of ID column to be referenced by other . I have a small set of records
> which each row is associated with a larger text file and gif file. So
> I try to put the large word ( or PDF that will include some picture in
> it) into another table but use a foreign ID to reference them. Thanks.
>
> C CHang
>
Received on Mon Jan 14 2002 - 02:38:01 CST

Original text of this message

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