17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE FUNCTION TEST1(V_ID VARCHAR2) RETURN SYS_REFCURSOR IS
RESULT SYS_REFCURSOR;
BEGIN
OPEN RESULT FOR
SELECT T1.ID, T2.NAME, T2.VALUE
FROM (SELECT V_ID ID FROM DUAL) T1,
(SELECT ID, NAME, VALUE FROM TEST) T2
WHERE T1.ID = T2.ID(+);
RETURN(RESULT);
END TEST1;