6 Replies Latest reply: Mar 19, 2014 3:45 AM by AlexAA RSS

    Passing value to the where clause with out page submit

    vballeda

      Dear Friends,

       

      I have a requirement like when I select a select list value I have to pass this value to sql query where clause without submitting the page

       

      ex  I have a select like :P1_Dept  suppose I select value 10 from this

       

      then I have a query select * from emp where deptno =  :P1_Dept.

       

       

      DB . ORACLE 11G

       

      APEX 4.1.1.00.23

       

      is it possible ? can any one please help me about this

       

      Thanks & Regards

       

      Vballeda