This content has been marked as final. Show 4 replies
There is no link between EULn_DOCUMENTS and the folders used by the worksheet. The SQL code in the worksheet itself is in a binary format and therefore cannot be read in a query. If you want to get the SQL for a workbook the easiest way is to use the Discoverer Desktop SQL export which will give you the SQL query for the worksheet you export.
If the SQL is stored in binary, then what is the SQL in EUL5_OBJS and EUL5_SEGMENTS?
Another developer had selected a report, in Discoverer and opened the SQL, copy/pasted it to an email for me. I found the text of the SQL in EUL5_OBJS and EUL5_SEGMENTS. Unfortunately, it turned out it was the query from the wrong report.
Anyway, there's at least two stores of SQL: EUL5_DOCUMENTS, in an illegible binary form, and EUL5_OBJS/EUL5_SEGMENTS, in clear text.