Skip to Main Content

Geting Apex pivot SQL

Robert_DMar 14 2017 — edited Mar 15 2017

Hello All,

I need to get SQL from pivoted IR. Function apex_050100.get_report_sql, is returnig only base report SQL, not pivoted one. 

I work on Apex 5.1.

DECLARE

   v_sql   VARCHAR2 (4000);

BEGIN

   v_sql := get_report_sql (<app_id>,<page_id>, FALSE);

   dbms_output.put_line(v_sql);

END;

Comments
Post Details
Added on Mar 14 2017
4 comments
306 views