execute immediate 語法小結

execute immediate 語法小結
查詢語句：
單條記錄：
execute immediate
'select a.dummy from dual' into v_dummy;

多條記錄：
execute immediate
'select dbms_random.value(0,1) from dual connect by rownum <= 10'
bulk collect into v_dummy;

使用繫結變數：
execute immediate
'select dbms_random.value(0,1) from dual connect by rownum <= :1'
bulk collect into v_dummy
using rowcnt;

更新語句：
更新並獲取單個所更新記錄：
execute immediate
'update test t set t.flag = 1 where t.id = 10 returning t.name into :1'
returning into v_name;

更新並獲取多個所更新記錄：
execute immediate
'update test t set t.flag = 1 where t.name like ''jack%'' returning t.name into :1'
returning bulk collect into v_names;
delete和insert 語句與update基本類似。