I want to get the query text of a report query in a application from APEX data dictionary .
The problem is when I select from this tables : ( WWV_FLOW_SHARED_QUERIES ) , it only returns the first query that I've written in that report query . I mean in simple words if I change the report query , the changes won't be applied on the QUERY_TEXT column of WWV_FLOW_SHARED_QUERIES table . Also it won't display all queries of a report query .
Am I selecting from a wrong table for this approach ? Which table from APEX data dictionary should I select ?
Ant help would be appreciated Thanks.
the wwv_flow* tables are the internal APEX tables. You should not use those for anything. Instead use views starting with APEX_* . These views will always match the current APEX version. They are documented in the view APEX_DICTIONARY. That view has one row per column in each view. Column "0" has the info about the view.