The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT char_id,
name,
prompt,
data_entry_hint,
datatype,
display_length,
decimal_precision,
default_value,
mandatory_flag,
uom_code,
target_value,
upper_spec_limit,
lower_spec_limit,
upper_reasonable_limit,
lower_reasonable_limit,
upper_user_defined_limit,
lower_user_defined_limit,
hardcoded_column,
developer_name,
sql_validation_string,
enabled_flag,
values_exist_flag,
fk_lookup_type,
fk_meaning
FROM qa_chars
WHERE char_id = e_id;
SELECT QC.char_id,
QC.name,
QC.prompt,
QC.data_entry_hint,
QC.datatype,
QC.display_length,
QC.decimal_precision,
QC.default_value,
QC.mandatory_flag,
QC.uom_code,
QC.target_value,
QC.upper_spec_limit,
QC.lower_spec_limit,
QC.upper_reasonable_limit,
QC.lower_reasonable_limit,
QC.upper_user_defined_limit,
QC.lower_user_defined_limit,
QC.hardcoded_column,
QC.developer_name,
QC.sql_validation_string,
QC.enabled_flag,
QC.values_exist_flag,
QC.fk_lookup_type,
QC.fk_meaning
FROM qa_chars QC,
qa_plan_chars QPC
WHERE QC.char_id = QPC.char_id
AND QPC.plan_id = p_id
AND QPC.enabled_flag = 1;
new_string := 'SELECT CODE FROM (' ||
'SELECT ''1'' CODE, ''1'' DESCRIPTION ' ||
'FROM SYS.DUAL WHERE 1=2 ' ||
'UNION ALL (' ||
new_string ||
') )';
SELECT char_id
FROm qa_chars
WHERE name = p_element_name
AND enabled_flag = 1;