Wednesday, January 11, 2012

sp_helptext for views in Oracle

So easy and I didn’t know...

 

select VIEW_NAME, TEXT
from all_views     
where
      VIEW_NAME =
'MYVIEW'