10 Replies Latest reply on Jun 18, 2019 11:12 AM by eric.sacramento

    Reflect column name on dynamic query

    Moshe Mallal

      Hi All,

       

      I created a list of tables and set it on my menu.

      I have one page which receive item (P1_TABLE_NAME) and shows column and datatype of the the table.

       

      I want on the same page also to see the data on that table - so I used dynamic query :

      select * from|| P1_TABLE_NAME

       

      and set Use Generic Column Names -> Yes

      Generic Column count : 20

       

      So now I have the table data but the columns name are col1,col2,col3 etc.

       

      How can I change it so the real columns shows.

       

      Attached screen shots for better understanding.

       

      Thanks,

      Moshe.

       

       

      APEX_1.jpgapex_2.JPG