To get a view definition:

Code:
SELECT text
FROM user_views
WHERE view_name = [view_name];