DBA Data[Home] [Help]

SYS.DBMS_JAVA SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 189

      execute immediate 'select sys.dbms_java_misc.runjava(1) from dual';
Line: 194

      execute immediate 'select sys.dbms_java_misc.runjava_in_current_session(1) from dual';
Line: 678

    cursor c1 is select owner, object_type
                        from dba_objects where
                        (object_type='JAVA CLASS' or
                         object_type='JAVA RESOURCE' or
                         object_type='JAVA SOURCE') and
                        (owner != 'SYS' and owner != 'SYSTEM' and
                         owner != 'EXFSYS' and owner != 'MDSYS'
                         and owner != 'ORDSYS');
Line: 750

    cursor c1 is select owner, object_type
                        from dba_objects where
                        (object_type='JAVA CLASS' or
                         object_type='JAVA RESOURCE' or
                         object_type='JAVA SOURCE') and
                        (owner = 'SYS' or owner = 'SYSTEM' or
                         owner = 'EXFSYS' or owner = 'MDSYS'
                         or owner = 'ORDSYS');