Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Geting Apex pivot SQL

Robert_D.Mar 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

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 12 2017
Added on Mar 14 2017
4 comments
428 views