Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: how to insert a long column in a store procedure

Re: how to insert a long column in a store procedure

From: luio <lctNOlcSPAM_at_hotmail.com.invalid>
Date: 2000/08/02
Message-ID: <02df20a0.54c4f5e4@usw-ex0104-028.remarq.com>#1/1

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 Wed Aug 02 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US