PL/sql question

I now sb. has answered this question several times. But I still could not find the solution for my case:

create table tb2(x long);
what I want to do is that in my store procedure

insert into tb2(x) select x from tb2.

copy one row from tb2 to a new row.

is there any simply way to do this in my store procedure?

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Aug 03 2000 - 00:00:00 CDT