Oracle中的Function可以返回自定义的数据集,记录参考如下:
1,Object对象
/*自定义类型 OBJECT Type*/
CREATE OR REPLACE TYPE EMP_ID_TYPE AS OBJECT(org_cd varchar2(10));
2,Table对象
/*自定义类型 TABLE Type*/
CREATE OR REPLACE TYPE EMP_ID_TABLE AS TABLE of EMP_ID_TYPE;
3,编写Function
CREATE OR REPLACE FUNCTION F_EMP_LIST ()
RETURN EMP_ID_TABLE PIPELINED IS
CURSOR emp_list_cursor is
select '20001' as emp_id from dual union
select '20002' as emp_id from dual union
select '20003'