System Tables Data Dictionary Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. System Tables Data Dictionary
  4. SELECT owner, NAME, plsql_warnings FROM user_plsql_object_settings
SQL>  SELECT owner, NAME, plsql_warnings
  2    FROM user_plsql_object_settings
  3   WHERE plsql_warnings LIKE '%DISABLE%'
  4     AND owner NOT IN ('SYS', 'SYSTEM');
   AND owner NOT IN ('SYS', 'SYSTEM')
SQL>