Tuesday, July 14, 2009

Get source code/script of a view

You can use this query to get the script of your view quickly.


SELECT TEXT
FROM all_views
WHERE VIEW_NAME = 'Your View Name'

No comments:

Post a Comment

Oracle Query