PIPELINED

[PL/SQL] 파이프라인 테이블함수

파이프라인 테이블함수(PIPELINED TABLE FUNCTION) 12345678910111213CREATE OR REPLACE FUNCTION 함수명 (매개변수) RETURN 컬렉션타입 PIPELINEDIS ...BEGIN ... LOOP PIPE ROW(반환데이터); END LOOP; RETURN;END;Colored by Color Scriptercs 예제123456789101112131415CREATE OR REPLACE FUNCTION FN_CH14_PIPE_TABLE (P_N NUMBER) RETURN CH14_NUM_AT PIPELINEDIS VNT_RETURN CH14_NUM_AT := CH14_NUM_AT();BEGIN FOR IDX IN 1..P_N LOOP VNT_RETURN.EXT..