Pages

▼

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
at

No comments:

Post a Comment

Loved my post? Or hated it? Or do you want me to write about something? Let me know in a comment :)