I have plugin, which works with report. But report gets data from "PL\SQL bode returning SQL query". I use "Use Generic Column Names (parse query at runtime only)" and column name is "COL1, COL2,COL3...", but i want to get database alias and i changed it to my header.
For example, select a.text, a.name from dual .
I know that a.text = 'field1' , a.name ='field2';
Maybe i can find alias from query in apex_application_page_rpt_cols or anywhere else ?
Would you provide a sample on apex.oracle.com to be able to help you effectively