oracle±éÀú½á¹û¼¯±ØÐëÒªÓÃÓαêÂð£¿

declare
v_str varchar2(500);
type red is record
(
v_id integer,
v_name varchar2(30)
);
re red;
begin
v_str := 'select id,name from a1 ';
execute immediate v_str into re;
for i in 1..re.count loop
dbms_output.put_line(i.v_id||''||i.v_name);
end loop;
end;



ÎÒÕâÑùд(re.count) ±¨´í ±¨±ØÐë˵Ã÷count ×é¼þ ¡£ÇëÎʲ»Í¨¹ýÓαêÄܱéÀúÕâЩ¼Ç¼¼¯Âð£¿
»¹ÓÐ Ö»ÄÜÓÃÓαê±éÀú¼¯ºÏÂ𣿠»¹ÓÐʲôÆäËûµÄ·½·¨£¿

---

Êý×éÒ²¿ÉÒÔ

ÎÊÌâÊÇ£¬ÄãµÄ²éѯÓï¾ä·µ»Ø¶àÌõ¼Ç¼£¬into re£¬¶øreÖ»ÊǽÓÊÕÒ»Ìõ¼Ç¼£¬ËùÒÔ±¨´í¡£

ÄãÓ¦¸Ã½«reÉùÃ÷ΪredÀàÐ͵ÄÊý×é

---

ÎÒÊÔÊÔ¿´ лл£¡£¡

---

TYPE red_array IS TABLE OF red INDEX BY BINARY_INTEGER;
re red_array;
...

for i in 1..red_array.count loop
red_array(i).

---

ÒýÓÃ

TYPE red_array IS TABLE OF red INDEX BY BINARY_INTEGER;
re red_array;
...

for i in 1..red_array.count loop
red_array(i).

Õý½â£¬¿ÉÒÔÓÃtypeÀ´×öµÄ¡£

---

ÎҸղſ´ÁË execute immediate into
into ×Ö¾ä½ö½öÔÚµ¥ÐвéѯÖÐʹÓÃ,Ö¸¶¨ÖµÊDZäÁ¿»ò¼Ç¼¡£

---

¿ÉÒԲο¼Õâ¸ö~~
SQL code:

declare
type emp_type is table of emp%rowtype index by binary_i