목록loop (1)

헤르메스 LIFE

[Oracle] Pipelined Table Functions

출처 : https://oracle-base.com/articles/misc/pipelined-table-functions Table FunctionsDROP TYPE T_TF_TAB;DROP TYPE T_TF_ROW; CREATE TYPE T_TF_ROW AS OBJECT ( ID NUMBER, DESCRIPTION VARCHAR2(50));/ CREATE TYPE T_TF_TAB IS TABLE OF T_TF_ROW;/ -- BUILD THE TABLE FUNCTION ITSELF.CREATE OR REPLACE FUNCTION GET_TAB_TF ( P_ROWS IN NUMBER)RETURN T_TF_TABAS L_TAB T_TF_TAB := T_TF_TAB();BEGIN FOR I IN 1 .. ..
Database 2015. 10. 8. 16:55
이전 Prev 1 Next 다음