The following lines contain the word 'select', 'insert', 'update' or 'delete':
select num into x from v$parameter
where name='undo_management' and value='AUTO';
select segment_name into rollback_segment_name from dba_rollback_segs
where tablespace_name='SYSTEM' and next_extent*max_extents>100000000 and
status='ONLINE' and initial_extent>1000000 and rownum < 2;
select segment_name into deallocate_rollback_name
from dba_rollback_segs where segment_name = rollback_segment_name;
select rmjvmtime into rmjvmtime from java$jvm$status
where rmjvmtime = (select startup_time from v$instance);
select 0 into free from v$parameter2
where name='event' and value like '%10049 trace%'
and not exists (select * from v$parameter2
where name='event'
and value='10049 trace name all off');
select current_size into sga_target_value
from v$memory_dynamic_components
where component='SGA Target';
select sum(bytes) into free from v$sgastat where pool='java pool';
select bytes into free from v$sgastat
where name='free memory' and
pool='shared pool' and
bytes < shared_pool_limit;
select sum(length) into free from idl_ub1$,x$joxft
where obj#=joxftobn and bitand(joxftflags,96)!=0;
select sum(length) into free from idl_ub1$ u,obj$ o
where o.obj#=u.obj# and o.type#=56 and name like 'Locale%';
select sum(bytes) into free from dba_free_space
where tablespace_name='SYSTEM';
delete from java$jvm$steps$done where step = step_name;
select status, version into stat, registry_version from dba_registry
where comp_id='JAVAVM';
SELECT version INTO v from v$instance;
select action,inprogress into lastaction,inprogress from java$jvm$status;
insert into java$jvm$status values('NONE','N',null,null,'TRUE');
update java$jvm$status set punting = 'TRUE';
update java$jvm$status set punting = 'FALSE';
update java$jvm$status set
action = newaction,
inprogress = 'Y',
execid = currentexecid,
punting = 'FALSE';
update java$jvm$status set punting = 'FALSE';
select action into action from java$jvm$status where
punting = 'FALSE' and
execid = currentexecid;
delete from java$jvm$steps$done;
update java$jvm$status set inprogress = 'N', execid = null;
update java$jvm$status set punting = 'FALSE';
update java$jvm$status set action = 'LOAD';
select execid, punting into execid, punting from java$jvm$status;
update java$jvm$status set punting = 'TRUE';
select step into oldstep from java$jvm$steps$done where step = newstep;
update java$jvm$status set punting = 'TRUE';
update java$jvm$status set punting = 'TRUE';
insert into java$jvm$status values('NONE','N',null,null,'TRUE');
insert into java$jvm$steps$done values(current_step);
update java$jvm$status set punting = 'FALSE';
select sid||'-'||serial# into execid from v$session
where sid = (select unique(sid) from v$mystat);
update obj$ set status=5 where obj#=(select obj# from obj$,javasnm$
where owner#=0 and type#=29 and short(+)=name and
nvl(longdbcs,name)='oracle/aurora/rdbms/Compiler');
cursor C1 is select
u.name, o.name
from obj$ o,user$ u where o.type#=56 and u.user#=o.owner#;
select count(*) into iterations from obj$ where type#=56;
drp('delete from java$policy$shared$table');
update obj$ set status=1 where obj#=(select obj# from obj$,javasnm$
where owner#=0 and type#=29 and short(+)=name and
nvl(longdbcs,name)='oracle/aurora/rdbms/Compiler');
'select * from sys.java$jvm$system$property$defs ' ||
'where user_name=SYS_CONTEXT(''userenv'',''SESSION_USER'') ' ||
'with check option');
exec('grant update,select,delete,insert on ' ||
'SYS.java_system_property_settings to public');