2 Replies Latest reply: Jul 4, 2013 4:56 AM by Ramani_apex RSS

    Apex - SQL query report.

    vk


      Hi,

      Apex - 4.0 and Oracle -11g

      I m having a SQL Query report.

      Query

       

       

      SELECT htmldb_item.hidden(1,id) id,
        htmldb_item.select_list_from_query_xl(2,name,'SELECT name ,                                                              

      deptid                                                     

      FROM  emp                                                     

      WHERE name like ''E%''') name,
        htmldb_item.select_list_from_query_xl(3,deptname,'SELECT  deptname from dept where deptid =   ???') deptname
      FROM tabel

      My problem, in the report when the Select list for 'name' has been choosen , then it should retrieve the deptname based on the 'name'.

      Is it possible ?