Re: Storing a file (exe, pdf, doc etc) on a db

From: Business <ihatespam_at_nomail.com>
Date: Fri, 5 Jan 2001 14:18:13 -0500
Message-ID: <935626$ccr$1@msunews.cl.msu.edu>

In a single word: No.

If you are running 8i, you should use dbms_lob to push data in and out using buffers.

You can also use the SQL*Loader to pull binary data in and out.

If you use the BFile data type, you don't even need to store the data in the database.

Every database handles LOB data differently.

<dipen2001_at_hotmail.com> wrote in message news:93526u$t7i$1_at_nnrp1.deja.com...
> Hi,
>
> Is there a standard insert statement(or similar) I can use to insert a
> file into a binary datatype on any db (ie oracle, sqlserver etc)?
>
> Many Thanks in advance!
>
>
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Jan 05 2001 - 13:18:13 CST