本文共 776 字，大约阅读时间需要 2 分钟。
慕尼黑的夜晚无繁华
Example 1:Output:ABCDECLARE TYPE var_typ IS TABLE OF VARCHAR2(4000);
cVars var_typ;
cVar VARCHAR2(4000);BEGIN
EXECUTE IMMEDIATE ' SELECT ''A'' cc FROM dual
UNION
SELECT ''B'' cc FROM dual
UNION
SELECT ''C'' cc FROM dual' BULK COLLECT INTO cVars; FOR i IN 1 .. cVars.COUNT
LOOP
cVar := cVars(i);
dbms_output.put_line (cVar); END LOOP;END;/ Example 2:Output:A CB DC EDECLARETYPE rec IS
RECORD
(
col1 VARCHAR2(30),
col2 VARCHAR2(30) );
TYPE rec_table IS TABLE OF rec;
results rec_table;
tRow rec;BEGIN
EXECUTE IMMEDIATE ' SELECT ''A'',''C'' FROM dual
UNION
SELECT ''B'',''D'' FROM dual
UNION
SELECT ''C'',''E'' FROM dual' BULK COLLECT INTO results; FOR i IN 1 .. results.COUNT
LOOP
tRow := results(i);
dbms_output.put_line(tRow.col1 || ' ' || tRow.col2); END LOOP;END;/
转载地址：https://blog.csdn.net/weixin_39987847/article/details/116328951 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！
发表评论
最新留言
关于作者
