SQL>
SQL> set heading off
SQL> set feedback off
SQL> set linesize 80
SQL>
SQL> select 'alter TRIGGER "' || object_name || '" compile;'
2 from user_objects
3 where object_type = 'TRIGGER'
4 and status = 'INVALID'
5 /
alter TRIGGER "LOG_SHUTDOWN" compile;
alter TRIGGER "LOG_STARTUP" compile;
alter TRIGGER "EMP_NAME_CHANGE" compile;
alter TRIGGER "IO_BIFER_DEPT_EMP_VIEW" compile;
SQL>
SQL> set heading on
SQL> set feedback on
SQL>
SQL> select 'show errors trigger ' || object_name
2 from user_objects
3 where object_type = 'TRIGGER'
4 and status = 'INVALID'
5 /
'SHOWERRORSTRIGGER'||OBJECT_NAME
--------------------------------------------------------------------------------
show errors trigger LOG_SHUTDOWN
show errors trigger LOG_STARTUP
show errors trigger EMP_NAME_CHANGE
show errors trigger IO_BIFER_DEPT_EMP_VIEW
4 rows selected.
SQL>