Query user_objects for all java classes : user_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. user_objects
SQL>
SQL> SELECT object_name shortname,
  2         DBMS_JAVA.LONGNAME (object_name) longname
  3    FROM USER_OBJECTS
  4    WHERE object_type = 'JAVA CLASS'
  5      AND object_name != DBMS_JAVA.LONGNAME (object_name);
    AND object_name != DBMS_JAVA.LONGNAME (object_name)
                       *
ERROR at line 5:
ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier


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