SYSTEM.AD_INST SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

    select object_name, object_type from dba_objects
    where owner = upper(compile_schema.in_schema)
    and   status = 'INVALID'
    and   object_type = 'PACKAGE';

Line: 29

    select object_name, object_type from dba_objects
    where owner = upper(compile_schema.in_schema)
    and   status = 'INVALID'
    and   object_type = 'VIEW';

Line: 34

    select object_name, object_type from dba_objects
    where owner = upper(compile_schema.in_schema)
    and   status = 'INVALID'
    order by decode(object_type,'PACKAGE',1,'VIEW',2,'PACKAGE BODY',4,3);