摘要:
Bulk collect当没有数据抛出异常跟implicit cursor 处理不一样。先看一下implicit cursor的处理吧:cl scr;DECLARE l_descr hardware.descr%type;BEGIN SELECT descr INTO l_descr FROM ... 阅读全文
摘要:
上一篇讲到了调用集锦,这篇关注一下性能问题吧。DECLARE CURSOR c_tool_list IS SELECT descr d1 FROM hardware; l_descr hardware.descr%type;BEGIN OPEN c_tool_list; LOOP ... 阅读全文