ORACLE游标学习笔记2-12-2010.docVIP

2010.12.2 Thursday Cloudy Cursor 普通定义 Cursor new_cursor is select * form EMP; 打开游标 Open new_cursor; 循环游标 loop loop fetch new_cursor into **** ; exit when new_cursor%notfound; *********(condition); end loop; 1 A:id,age,column1,column2?B:id,age,column1,column2?A.id 与 B.id关联。?将B中age40的column1,column2更新到A的相应记录中，只能写一个语句。 create?table?A?(?? ????id??????varchar2(1),?? ????column1?varchar2(1),?? ????column2?varchar2(1)?? )?? /?? create?table?B?(?? ????id??????varchar2(1),?? ????column1?varchar2(1),?? ????column2?varchar2(1),?? ????age?????number?? )??