How to get SQL query from a view at Oracle
Today I have just one top for all of you who are searching how to work with views in Oracle documentation for as long time as I do. If you have a view over tables in database and you want to know what SQL query is executed you can obtain the query using following query:
SELECT text FROM all_views WHERE view_name = '%VIEW_NAME%';
