Getting the definition of a view out of oracle
May 25, 2010 Leave a comment
I know I’ll have to do this again one day so….
SQL> set long 10000
SQL> select TEXT
2 FROM DBA_VIEWS
3 where OWNER = ‘<owner_name>’
4 and VIEW_NAME = ‘<view_name>’;