Getting the SQL Script behind a Graphical Calculation View

[rehanshaikh]

I want to see the SQL script that is generated when I run my graphical calculation. By this I do not mean the select statement that extracts data from the view, but the statement that gets data from the database itself which includes the names of tables used inside the calculation view. Does anyone know of a way to do this?

Thanks.

[Former Member]

Hi Rehan,

You can get the information about tables used in the CV from explain plan or the visualize plan.

-Avinash

[rehanshaikh]

Thanks Avinash, this was definitely helpful.