Instant SQL formatter
May 25, 2010 Leave a comment
Does what it says on the tin – http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz
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>’;
Dan's BI Braindump 