The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
template_id,
template_type,
template_name,
base_processing_priority,
business_group_id,
legislation_code,
version_number,
base_name,
max_base_name_length,
preference_info_category,
preference_information1,
preference_information2,
preference_information3,
preference_information4,
preference_information5,
preference_information6,
preference_information7,
preference_information8,
preference_information9,
preference_information10,
preference_information11,
preference_information12,
preference_information13,
preference_information14,
preference_information15,
preference_information16,
preference_information17,
preference_information18,
preference_information19,
preference_information20,
preference_information21,
preference_information22,
preference_information23,
preference_information24,
preference_information25,
preference_information26,
preference_information27,
preference_information28,
preference_information29,
preference_information30,
configuration_info_category,
configuration_information1,
configuration_information2,
configuration_information3,
configuration_information4,
configuration_information5,
configuration_information6,
configuration_information7,
configuration_information8,
configuration_information9,
configuration_information10,
configuration_information11,
configuration_information12,
configuration_information13,
configuration_information14,
configuration_information15,
configuration_information16,
configuration_information17,
configuration_information18,
configuration_information19,
configuration_information20,
configuration_information21,
configuration_information22,
configuration_information23,
configuration_information24,
configuration_information25,
configuration_information26,
configuration_information27,
configuration_information28,
configuration_information29,
configuration_information30,
object_version_number
from pay_element_templates
where template_id = p_template_id;
select template_id,
template_type,
template_name,
base_processing_priority,
business_group_id,
legislation_code,
version_number,
base_name,
max_base_name_length,
preference_info_category,
preference_information1,
preference_information2,
preference_information3,
preference_information4,
preference_information5,
preference_information6,
preference_information7,
preference_information8,
preference_information9,
preference_information10,
preference_information11,
preference_information12,
preference_information13,
preference_information14,
preference_information15,
preference_information16,
preference_information17,
preference_information18,
preference_information19,
preference_information20,
preference_information21,
preference_information22,
preference_information23,
preference_information24,
preference_information25,
preference_information26,
preference_information27,
preference_information28,
preference_information29,
preference_information30,
configuration_info_category,
configuration_information1,
configuration_information2,
configuration_information3,
configuration_information4,
configuration_information5,
configuration_information6,
configuration_information7,
configuration_information8,
configuration_information9,
configuration_information10,
configuration_information11,
configuration_information12,
configuration_information13,
configuration_information14,
configuration_information15,
configuration_information16,
configuration_information17,
configuration_information18,
configuration_information19,
configuration_information20,
configuration_information21,
configuration_information22,
configuration_information23,
configuration_information24,
configuration_information25,
configuration_information26,
configuration_information27,
configuration_information28,
configuration_information29,
configuration_information30,
object_version_number
from pay_element_templates
where template_id = p_template_id
for update nowait;