The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
competence_id,
name,
business_group_id,
object_version_number,
description,
date_from,
date_to,
behavioural_indicator,
certification_required,
evaluation_method,
renewal_period_frequency,
renewal_period_units,
min_level,
max_level,
rating_scale_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
competence_alias,
competence_definition_id
,competence_cluster -- BUG3356369
,unit_standard_id
,credit_type
,credits
,level_type
,level_number
,field
,sub_field
,provider
,qa_organization
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
from per_competences
where competence_id = p_competence_id;
select competence_id,
name,
business_group_id,
object_version_number,
description,
date_from,
date_to,
behavioural_indicator,
certification_required,
evaluation_method,
renewal_period_frequency,
renewal_period_units,
min_level,
max_level,
rating_scale_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
competence_alias,
competence_definition_id
,competence_cluster -- BUG3356369
,unit_standard_id
,credit_type
,credits
,level_type
,level_number
,field
,sub_field
,provider
,qa_organization
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
from per_competences
where competence_id = p_competence_id
for update nowait;