6 Replies Latest reply on Mar 19, 2014 8:45 AM by AlexAA

    Passing value to the where clause with out page submit


      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




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


      Thanks & Regards