The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT request_id INTO result
FROM fnd_concurrent_requests
WHERE concurrent_program_id IN (SELECT concurrent_program_id
FROM fnd_concurrent_programs
WHERE concurrent_program_name = prog_name)
AND phase_code = 'R';
SELECT owner INTO apps
FROM sys.dba_objects
WHERE object_name = 'OKC_CHR_KEYWORD_PVT'
AND object_type = 'PACKAGE';
SELECT owner INTO okc
FROM sys.dba_tables
WHERE table_name = 'OKC_K_HEADERS_TL';
SELECT 'Y' INTO yes_no
FROM ctxsys.ctx_objects
WHERE obj_class = 'LEXER'
AND obj_name = 'CHINESE_LEXER';
SELECT 'Y' INTO yes_no
FROM ctxsys.ctx_objects
WHERE obj_class = 'LEXER'
AND obj_name = 'JAPANESE_LEXER';
SELECT 'Y' INTO yes_no
FROM ctxsys.ctx_objects
WHERE obj_class = 'LEXER'
AND obj_name = 'KOREAN_MORPH_LEXER';
SELECT par_value INTO l_max_memory
FROM ctx_parameters
WHERE par_name = 'MAX_INDEX_MEMORY';
SELECT value INTO l_cpu_count
FROM v$parameter
WHERE name = 'cpu_count';