System Tables Data Dictionary Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. System Tables Data Dictionary
  4. Query user_objects for all java classes
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>