This discussion is archived
14 Replies Latest reply: Jan 24, 2013 4:23 AM by 983316 RSS

condition in APEX_ITEM.checkbox2

983316 Newbie
Currently Being Moderated
Hello, 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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points