The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
configuration_code
,configuration_context
,location_id
,location_code
,description
,style
,address_line_1
,address_line_2
,address_line_3
,town_or_city
,country
,postal_code
,region_1
,region_2
,region_3
,telephone_number_1
,telephone_number_2
,telephone_number_3
,loc_information13
,loc_information14
,loc_information15
,loc_information16
,loc_information17
,loc_information18
,loc_information19
,loc_information20
,object_version_number
from per_ri_config_locations
where location_id = p_location_id;
select
configuration_code
,configuration_context
,location_id
,location_code
,description
,style
,address_line_1
,address_line_2
,address_line_3
,town_or_city
,country
,postal_code
,region_1
,region_2
,region_3
,telephone_number_1
,telephone_number_2
,telephone_number_3
,loc_information13
,loc_information14
,loc_information15
,loc_information16
,loc_information17
,loc_information18
,loc_information19
,loc_information20
,object_version_number
from per_ri_config_locations
where location_id = p_location_id
for update nowait;