Re: From raw to lob

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 2000/03/03
Message-ID: <89pbrf$43v$1@nnrp1.deja.com>#1/1

In article <89p4h2$1ci$1_at_lacerta.tiscalinet.it>, "Dimm" <Dimm_at_kataweb.it> wrote:
> Hi all,
>
> Is there a function for to convert a data long raw or long to clob or
blob?
>
>

In Oracle8i, release 8.1 (and not in 8.0) -- yes. there is the function to_lob().

You can

insert into t ( blob_column) select to_lob(long_raw_col) from another_t;

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Fri Mar 03 2000 - 00:00:00 CST