Re: What type to store Excel files in database?

From: <chandrasekar_at_my-dejanews.com>
Date: Wed, 03 Feb 1999 16:00:00 GMT
Message-ID: <799rpq$ib6$1@nnrp1.dejanews.com>

Hi,

     In ORACLE 8.0.3.0 and above u can use BFILE datatype to store the entire EXCEL file in ORACLE . But strictly speaking the file is physically stored in the OS but a locator would be stored in the database table cloumns.

                  An alternative for this is using BLOB datatype which stores

any type of formatted data in the ORACLE databaes itself. I 'ope this helps u .
Revert back for further clarifications .

regards
G. CHANDRASEKAR In article <793jh8$9ib$1_at_nnrp1.dejanews.com>,   bonanos_at_yahoo.com wrote:
> Hi Caleb
>
> > How do I and what type should I store Excel files in the database
> > tables?
>
> This question is a bit vague. Are you talking about 8i , context or perhaps
> impoting the data into the database?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 03 1999 - 10:00:00 CST