Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Check user_objects for object name

SQL> SQL> SELECT object_name, object_type, status   2  FROM   user_objects   3  WHERE  OBJECT_NAME IN ('TEST_PACK', 'CALL_TEST_PROC')   4  and    rownum < 50   5  ORDER BY object_name, object_type; OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE         STATUS ------------------- ------- CALL_TEST_PROC PROCEDURE           VALID TEST_PACK PACKAGE             VALID TEST_PACK PACKAGE BODY        VALID SQL>