Function Body Returning SQL Query in LOV
Function Body Returning SQL Query in LOV
DECLARE
V_QUERY VARCHAR2(4000);
BEGIN
IF :P3_TYPE = 1 THEN
V_QUERY := 'select department_name d, id r from dept';
ELSE
V_QUERY := 'select name d, id r from emp';
END IF;
RETURN V_QUERY;
END;