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.