use dynamic sql such as (just a sample): type curtype is ref cursor; curname curtype; str := 'select * from tablename'; open cursorname for str; loop fetch aaa into rowtype_var; end loop;
btw: search 'dynamic sql' in oracle's handbook you can find the sample in detail.
在pl/sql中该如何实现呢?
such as (just a sample):
type curtype is ref cursor;
curname curtype;
str := 'select * from tablename';
open cursorname for str;
loop
fetch aaa into rowtype_var;
end loop;
search 'dynamic sql' in oracle's handbook
you can find the sample in detail.