Forum Stats

  • 3,853,777 Users
  • 2,264,267 Discussions
  • 7,905,444 Comments

Discussions

How to retrieve SQL Query of a Discoverer Workbook?

Santosh Kumar Bhairi
Santosh Kumar Bhairi Member Posts: 17
edited Apr 26, 2017 6:34AM in Discoverer

Hello,

I am trying to retrieve the SQL Query of a Discoverer Workbook.  One of the option is to get it by opening/executing the workbook and get the SQL thru SQL Inspector.

Another option is to fetch the query stored in eul5_documents.doc_document column.  This column is of LONG RAW datatype which is no longer available and stores the results in hexa-decimal format.  I followed this post but the problem is retrieved output is not in readable format.

https://www.experts-exchange.com/questions/21512848/Oracle-Discoverer-9i-EUL5-Documents-table-Need-to-capture-Workbook-S…

Did anyone successfully retrieved SQL Query of a discoverer workbook?

Thanks,

Santosh

Answers

This discussion has been closed.