Re: How to copy a CLOB from one table to another using pl/sql

From: Ted Chyn <tedchyn_at_yahoo.com>
Date: 30 Aug 2001 11:37:40 -0700
Message-ID: <44a19320.0108301037.7d191d88_at_posting.google.com>


in pl/sql you can use dbms_lob.copy.
d_pal1_at_hotmail.com (Dev) wrote in message news:<e81d6448.0108240957.7f0faec7_at_posting.google.com>...
> The situation is, I have a table in which I have an id column and a
> column with datatype CLOB and I want to copy some of these clobs to
> another table with a clob datatype column.
> Can somebody specify how to copy a clob from one table to another
> using PL/Sql
> I tried using dbms_lob.copy but somehow that doesnt seem to be
> working.
> TIA
Received on Thu Aug 30 2001 - 20:37:40 CEST

Original text of this message