condition in APEX_ITEM.checkbox2
983316Jan 21 2013 — edited Jan 24 2013Hello, I would like to check some rows in in my report according to specific conditions, I am using a statement similar to this:
SELECT APEX_ITEM.CHECKBOX2(1,empno,DECODE(deptno,10,'CHECKED',NULL)) "Select",
ename, job
FROM emp
ORDER BY 1
The problem is that I couldn't apply more than one condition in the DECODE sentence, I tried to use CASE but didn't work too, or maybe I didn't use the right syntax. Could you help me giving me the right syntax to apply more than one condition?
Edited by: Najla on Jan 21, 2013 4:32 AM