REF Cursor

REF CURSOR WILL BE DYNAMICALLY OPENS OR OPEN BASED ON A LOGIC.

DECLARE
TYPE C1 IS REF CURSOR;
CURSOR C IS SELECT * FROM DUAL;
REF_CURSOR RC;
BEGIN
IF (TO_CHAR(SYSDATE,'DD') = 30 ) THEN
OPEN REF_CURSOR FOR 'SELECT * FROM TABLE1';
ELSIF ( TO_CHAR(SYSDATE,'DD') = 29 ) THEN
OPEN REF_CURSOR FOR SELECT * FROM TABLE2;
ELSE
OPEN REF_CURSOR FOR SELECT * FROM DUAL;
END IF;
OPEN C;
END;