Get text of a view from Oracle

There are no doubt other ways to get this, but what I've used is:

select TEXT 
          FROM DBA_VIEWS 
          where OWNER = 'THE_OWNER'  and VIEW_NAME  = 'THE_VIEW'

...and you'll need to substitute the correct owner name and view name.

results matching ""

    No results matching ""