Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>