Re: insert blob

From: Clive Walden <clivew_at_cts.com>
Date: Fri, 05 Jan 2001 16:42:10 -0800
Message-ID: <o2qc5ts67dhqgmq12nu8l1sjrnl5lejtrp@4ax.com>

Susanne,

I do not believe you can do this from an outside source using simple parameters.

However, for test data, archiving etc. once you have a record with a BLOB field you can replicate it using simple SQL of type

INSERT INTO MYNEWTABLE
SELECT * FROM MYOLDTABLE So if duplicated data is not a problem you can elaborate on this concept. The above is just one example, I "think" you can use simple SQL of many kinds to move BLOB fields within Oracle.

Clive

On Fri, 5 Jan 2001 11:52:59 +0100, "Clinique" <clinique_at_gmx.net> wrote:

>Hi everybody,
>can anyone tell me if there is any chance to insert blobs via a simple
>insert statement? I only need some testdata...
>
>Susanne
>
Received on Fri Jan 05 2001 - 18:42:10 CST