Wednesday, March 21, 2012

Get the sql query for a view in Oracle

Here is a tiny snippet to get the sql query for view in an Oracle database.



SELECT text

FROM all_views

WHERE view_name like '%VIEW_NAME%';




Happy Programming :)
Signing Off

Ryan

No comments: