The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
skill_provision_id,
activity_version_id,
object_version_number,
type,
comments,
tsp_information_category,
tsp_information1,
tsp_information2,
tsp_information3,
tsp_information4,
tsp_information5,
tsp_information6,
tsp_information7,
tsp_information8,
tsp_information9,
tsp_information10,
tsp_information11,
tsp_information12,
tsp_information13,
tsp_information14,
tsp_information15,
tsp_information16,
tsp_information17,
tsp_information18,
tsp_information19,
tsp_information20,
analysis_criteria_id
from ota_skill_provisions
where skill_provision_id = p_skill_provision_id;
select skill_provision_id,
activity_version_id,
object_version_number,
type,
comments,
tsp_information_category,
tsp_information1,
tsp_information2,
tsp_information3,
tsp_information4,
tsp_information5,
tsp_information6,
tsp_information7,
tsp_information8,
tsp_information9,
tsp_information10,
tsp_information11,
tsp_information12,
tsp_information13,
tsp_information14,
tsp_information15,
tsp_information16,
tsp_information17,
tsp_information18,
tsp_information19,
tsp_information20,
analysis_criteria_id
from ota_skill_provisions
where skill_provision_id = p_skill_provision_id
for update nowait;
select
skill_provision_id,
activity_version_id,
type,
comments,
tsp_information_category,
tsp_information1,
tsp_information2,
tsp_information3,
tsp_information4,
tsp_information5,
tsp_information6,
tsp_information7,
tsp_information8,
tsp_information9,
tsp_information10,
tsp_information11,
tsp_information12,
tsp_information13,
tsp_information14,
tsp_information15,
tsp_information16,
tsp_information17,
tsp_information18,
tsp_information19,
tsp_information20,
analysis_criteria_id
from ota_skill_provisions
where activity_version_id = p_activity_version_from;