Where The Streets Have No Name

http://scidb.tistory.com/entry/Pipelined-Table-Function-의-사용 http://www.oracle-developer.net/display.php?id=207

출처 : http://forums.oracle.com/forums/thread.jspa?threadID=385558 create or replace function fewcols(n in number,t in varchar2) return sys_refcursor is str varchar2(1000); opt sys_refcursor; begin for i in (select column_name from all_tab_cols where table_name = t and column_id select fewcols(4,'EMP') from dual; FEWCOLS(4,'EMP') -------------------- CURSOR STATEMENT : 1 CURSOR STATEMENT : 1 EMPNO..