Re: Rows Data

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 ?

Thanks

David

"Daniel Morgan" <damorgan_at_x.washington.edu> escribió en el mensaje news:1084196474.529891_at_yasure...
> David wrote:
>
> > Hello,
> >
> > Knows anybody how i can move data from a row to another row in the same
> > table?
> >
> > row A Data
> > 1
> > 2
> > 3
> > ....
> >
> > Move to row B (empy)
> >
> > I think that I can rename the rows, how i can do it?
> >
> > I'm using Oracle 8.1.7
> >
> > Thanks in advance.
> >
> > David
>
> http://www.psoug.org/reference/update.html
>
> May help.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Mon May 10 2004 - 10:11:33 CDT