Tuesday 10 May 2016

Query to Get The Code For a View

The relevant query is as follows:

SQL>     set long 10000

SELECT text
FROM    user_views
WHERE view_name = ‘<VIEW_NAME>’;

No comments:

Post a Comment