摘要： 游标 declare cursor vrows is select * from emp; vrow emp%rowtype;begin open vrows; loop fetch vrows into vrow; exit when vrows%notfound; dbms_output.put 阅读全文

摘要： 原句子 1merge into dept a using dept_bak b on (a.deptno=b.deptno)when matched then update set a.dname=b.dname, a.loc=b.locwhen not matched then insert (d 阅读全文