¹òÇó¸ßÊÖ½â´ðORACLE²Ù×÷±íµÄÎÊÌâ - Oracle / ¿ª·¢

SQL code:

create table A
(
a_id number primary key,
a_name varchar2(20),
a_colName varchar2(50)
);
create table B
(
b_id number primary key,
b_colName varchar2(50)
);
create table C
(
c_id number primary key,
c_name varchar(20)
);
create sequence seq_A;
create sequence seq_B;
create sequence seq_C;

insert into B values(seq_B.Nextval,'colName1');
insert into B values(seq_B.Nextval,'colName2');
insert into B values(seq_B.Nextval,'colName3');

insert into C values(seq_C.Nextval,'Name1');
insert into C values(seq_C.Nextval,'Name2');
insert into C values(seq_C.Nextval,'Name3');

insert into A(a_id,a_name) select seq_A.Nextval,c.c_name from C c

select * from A;
--ÏÔʾ½á¹û
-- A_ID A_NAME A_COLNAME
-- 1 Name1
-- 2 Name2
-- 3 Name3

--ÎÊÌâ ÔõÑù²ÅÄÜ°Ñ A_COLNAME ÁÐÌîÂú ÒªÇóÖµÊÇ´Ó B ±í b_colName ÁжøÀ´(¿¼ÂÇÐÔÄÜ)

--ÎÒÊÇÕâÑù×öµÄ £¬ÎÒÏ£ÍûÓÐÒ»ÖÖÄÜÅúÁ¿µÄ·½·¨ (oracle 10g)
declare
b_colname varchar2(15);
cursor mycur is select b.b_colname from B b ;
begin
open mycur;
loop
fetch mycur into b_colname;
--update A±í
exit when mycur%notfound;
dbms_output.put_line(b_colname );
end loop;
close mycur;
end;

---

Ö±½ÓÒ»¸öupdate£¬²»ÓÃÓαêºÍ¹ý³ÌÒ²Ðа¡
»òÕßÓÃforall

---

ÎÒÒªÅúÁ¿¸ÄµÄ Ò»ÌõÒ»ÌõÐÔÄܲ»