Re: Rows Data

David wrote:
>
> thank for your answer.
>
> I use
>
> UPDATE <table_name>
> SET <A> = (
> SELECT <B>
> FROM <table_name>);
>
> but gives an error: "Not a valid use for a LONG camp ".
>
> A = LONG
> B = CLOB
>
> How I can do it ?
> Can I transform A type, after update the rows, and finally change it to LONG
> ?

Try the following:

UPDATE <table_name>
SET A = (
  SELECT TO_LOB(B)
  FROM <table_name>);

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"