Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>