SQL>SQL> COL object_name FORMAT A15SQL> COL status FORMAT A10SQL>SQL> SELECT object_name, status FROM user_objects WHERE object_name = 'COMPILEERROR';OBJECT_NAME STATUS--------------- ----------COMPILEERROR VALID1 row selected.