Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Bhanu, if you check the option 'ALL' then you need to change your code accordingly: AND (DEPT.DEPT_NAME IN (:p_dept_name) OR 'ALL' IN (:p_dept_name || 'ALL')) Cheers