Archive for the ‘Oracle SQL’ Category.

Oracle SQL Snippet : Find Definition of a View

February 12, 2010, 1:48 am

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'
Category: Code Snippets, Oracle SQL  |  Comment