Check user_objects for object name : user_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial

SQL>
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>

30.90.user_objects
	30.90.1.	Check user_objects for object name
	30.90.2.	Check the package status in user_objects
	30.90.3.	Check function/procedure status
	30.90.4.	Check the status for all stored procedures is by using the Oracle data dictionary view USER_OBJECTS
	30.90.5.	Get invalid table objects by joining user_segments and user_objects
	30.90.6.	Get all invalid user objects in user_objects table
	30.90.7.	Create drop command by query the user_objects table
	30.90.8.	Create grant permission command by querying user_objects table
	30.90.9.	Query user_objects for all packages, procedures and functions
	30.90.10.	Query user_objects for user-defined data type
	30.90.11.	Recompile all invalid package
	30.90.12.	Query user_objects for all java classes
	30.90.13.	Query user_objects for all PL/SQL code
	30.90.14.	Get Object id from user_objects
	30.90.15.	Join sys.col$ and user_objects
	30.90.16.	Query user_objects for object status
	30.90.17.	Query user_objects for your functions and procedures
	30.90.18.	User and its average object id
	30.90.19.	Show the procedure is marked invalid **
	30.90.20.	Behavior of dependent objects.
	30.90.21.	Finding, Validating, and Describing Packages
	30.90.22.	If procedure is valid