在网上看到有种方法,但还是不行。
declare
fri_tab test_array;
begin
select friend into fri_tab
from friends
where id = 1;
for i in 1..fri_tab.count loop
dbms_output.put_line('id' || fri_tab(i));
end loop;
end;求帮助!
declare
fri_tab test_array;
begin
select friend into fri_tab
from friends
where id = 1;
for i in 1..fri_tab.count loop
dbms_output.put_line('id' || fri_tab(i));
end loop;
end;求帮助!
select f.id, r.* from friends f, table(f.friend) r;
基本上能解决了上面的问题。
SELECT t1.id,t2.* FROM friends t1,TABLE(t1.friend)t2;