14 Replies Latest reply: Jan 24, 2013 6:23 AM by 983316 RSS

    condition in APEX_ITEM.checkbox2

      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