This discussion is archived
1 Reply Latest reply: Jan 14, 2013 1:46 PM by Michael Armstrong-Smith RSS

Which workbooks containts graph

796605 Newbie
Currently Being Moderated
I need to know which workbooks are using graphs, the best would be to query it via EUL5_* tables but i can't find where the graph/chart info is available. Please help where to find such information?

Actually the only way i can think about is to export all the workbooks in xml format and search for files where <chart> tag is available, but this is time consuming.

Any other suggestion is welcome!

Thanks.

mcha
  • 1. Re: Which workbooks containts graph
    Michael Armstrong-Smith Oracle ACE
    Currently Being Moderated
    Hello ncha
    All workbooks that are saved to the database are saved to a file called EUL5_DOCUMENTS where DOC_NAME is the name of the workbook(s). The code for the workbook will be contained in a LONG RAW field called DOC_DOCUMENT.

    Because it is a LONG datatype you cannot use SQL to query it directly. However, you should be able to create a function that will allow you to convert the LONG into text and then you should be able to search for the word CHART.

    Not saying 100% that this will work but it might be worth a shot.

    For help on creating such a function I'd like to refer you here: http://www.dba-oracle.com/t_select_long_table_column_sql.htm

    Best wishes
    Michael

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points