下载地址:
下载地址1(本站为飞网专业下载站,域名:down.cfei.net)
资源简介:
oracle命令和参数说明%FOUND功能: 判断光标属性参见: %ISOPEN, %NOTFOUND, CURSOR, %ROWCOUNT语法:c1%FOUND 或 SQL%FOUNDc1 为PL/SQL 光标名字例子:PL/SQLLOOPFETCH loan_cursor INTO customer_name, loan_amount;IF loan_cursor%FOUND THENapproved_loan := loan_amount * 0.80;ELSEEXIT;END IF;END LOOP;INSERT INTO approved_loan VALUES (customer_name,loan_amount);IF SQL%FOUND THENCOMMIT;ELSEROLLBACK;END IF;
飞网下载站,免费下载共享资料,内容涉及教育资源、专业资料、IT资源、娱乐生活、经济管理、办公文书、游戏资料等。