declare
cur_id number;
cur_pname varchar(200);
cursor related_cursor IS
select model_id,project_name from t_svn_models where model_id = 5111551;
begin
open related_cursor;
loop
fetch related_cursor into cur_id,cur_pname;
exit when related_cursor%notfound;
insert into t_pmp_projects (project_id,project_name,svn_model_id,status) values
(SEQ_PROJECT.nextval,cur_pname,cur_id,4);
end loop;
close related_cursor;
end;
commit;
cur_id number;
cur_pname varchar(200);
cursor related_cursor IS
select model_id,project_name from t_svn_models where model_id = 5111551;
begin
open related_cursor;
loop
fetch related_cursor into cur_id,cur_pname;
exit when related_cursor%notfound;
insert into t_pmp_projects (project_id,project_name,svn_model_id,status) values
(SEQ_PROJECT.nextval,cur_pname,cur_id,4);
end loop;
close related_cursor;
end;
commit;
输出语句:
DBMS_OUTPUT.PUT_LINE('cur_parent_user_id:'||cur_parent_user_id);
DBMS_OUTPUT.PUT_LINE('cur_user_id:'||cur_user_id);
pl/sql 一个数据库连接到另外一个数据库后,在一个数据库中查询另外一个数据库的数据用的sql
insert into m_users (select * from m_users@pps32_oa_dev.com);
导入数据时候注意主键问题:如果主键用序列,则最好不要将ID也导入到表中以防止 自增的序列增加到与当前ID相同后出现错误