How to retrieve the SQL used to create a view in Oracle?

Question

In Oracle, to retrieve the SQL used to create a Function, Package, etc, the user_source view can be queried. However, views are not included in this view - nor do they exist in the underlying sys.source$. To access the text of views, the user_views.text column can be used, but this is not exact because Oracle will re-write some parts of the query, for example it will do glob expansion.

How can I retrieve the SQL used to create a view, exactly as it was entered, without glob expansion?

Answer 1

You can use the following query:

SELECT VIEW_NAME, TEXT FROM USER_VIEWS; 

or you can use ALL_VIEWS, as in

SELECT VIEW_NAME, TEXT  FROM ALL_VIEWS; 

References:

ALL_VIEWS on Oracle® Database Reference