pipelined table function 썸네일형 리스트형 [Oracle] Pipelined table function -- Pipelined table function /*** FORMAT : *** CREATE OR REPLACE FUNCTION . *** ( [IN | OUT | IN OUT] [NOCOPY] ) *** RETURN *** [AUTHID ] *** [] *** [PARALLEL_ENABLE (PARTITION BY [ (), ANY])] IS ***/ -- create demo table create table stocktable ( ticker varchar2(4), open_price number(10), close_price number(10)); insert into stocktable values ('orcl', 13,16); insert into stocktable values ('msft.. 더보기 이전 1 다음