DBA Data[Home] [Help]

SYSTEM.AD_COMPILE SQL Statements

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

Line: 11

  select owner, object_type, object_name
  from dba_objects
  where object_type in ('PACKAGE', 'PACKAGE BODY')
  and object_name in ('APPS_DDL', 'APPS_ARRAY_DDL')
  and status = 'INVALID'
  order by object_type, object_name desc;