The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
election_candidate_id
,business_group_id
,election_id
,person_id
,rank
,role_id
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,candidate_info_category
,candidate_information1
,candidate_information2
,candidate_information3
,candidate_information4
,candidate_information5
,candidate_information6
,candidate_information7
,candidate_information8
,candidate_information9
,candidate_information10
,candidate_information11
,candidate_information12
,candidate_information13
,candidate_information14
,candidate_information15
,candidate_information16
,candidate_information17
,candidate_information18
,candidate_information19
,candidate_information20
,candidate_information21
,candidate_information22
,candidate_information23
,candidate_information24
,candidate_information25
,candidate_information26
,candidate_information27
,candidate_information28
,candidate_information29
,candidate_information30
,object_version_number
from per_election_candidates
where election_candidate_id = p_election_candidate_id;
select
election_candidate_id
,business_group_id
,election_id
,person_id
,rank
,role_id
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,candidate_info_category
,candidate_information1
,candidate_information2
,candidate_information3
,candidate_information4
,candidate_information5
,candidate_information6
,candidate_information7
,candidate_information8
,candidate_information9
,candidate_information10
,candidate_information11
,candidate_information12
,candidate_information13
,candidate_information14
,candidate_information15
,candidate_information16
,candidate_information17
,candidate_information18
,candidate_information19
,candidate_information20
,candidate_information21
,candidate_information22
,candidate_information23
,candidate_information24
,candidate_information25
,candidate_information26
,candidate_information27
,candidate_information28
,candidate_information29
,candidate_information30
,object_version_number
from per_election_candidates
where election_candidate_id = p_election_candidate_id
for update nowait;