Oracle SQL Snippet : Find Definition of a View
To find the definition of view SYS.ALL_TABLES use the following SQL code
select TEXT
from DBA_VIEWS
where OWNER = 'SYS'
and VIEW_NAME = 'ALL_TABLES'
Just another WordPress weblog
To find the definition of view SYS.ALL_TABLES use the following SQL code
select TEXT
from DBA_VIEWS
where OWNER = 'SYS'
and VIEW_NAME = 'ALL_TABLES'