Getting the definition of a view out of oracle

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>’;

 

Unknown's avatarAbout Dan Wakefield
BI / Data Warehouse Developer

Leave a comment