The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
previous_job_extra_info_id
,previous_job_id
,information_type
,pji_attribute_category
,pji_attribute1
,pji_attribute2
,pji_attribute3
,pji_attribute4
,pji_attribute5
,pji_attribute6
,pji_attribute7
,pji_attribute8
,pji_attribute9
,pji_attribute10
,pji_attribute11
,pji_attribute12
,pji_attribute13
,pji_attribute14
,pji_attribute15
,pji_attribute16
,pji_attribute17
,pji_attribute18
,pji_attribute19
,pji_attribute20
,pji_attribute21
,pji_attribute22
,pji_attribute23
,pji_attribute24
,pji_attribute25
,pji_attribute26
,pji_attribute27
,pji_attribute28
,pji_attribute29
,pji_attribute30
,pji_information_category
,pji_information1
,pji_information2
,pji_information3
,pji_information4
,pji_information5
,pji_information6
,pji_information7
,pji_information8
,pji_information9
,pji_information10
,pji_information11
,pji_information12
,pji_information13
,pji_information14
,pji_information15
,pji_information16
,pji_information17
,pji_information18
,pji_information19
,pji_information20
,pji_information21
,pji_information22
,pji_information23
,pji_information24
,pji_information25
,pji_information26
,pji_information27
,pji_information28
,pji_information29
,pji_information30
,object_version_number
from per_prev_job_extra_info
where previous_job_extra_info_id = p_previous_job_extra_info_id;
select
previous_job_extra_info_id
,previous_job_id
,information_type
,pji_attribute_category
,pji_attribute1
,pji_attribute2
,pji_attribute3
,pji_attribute4
,pji_attribute5
,pji_attribute6
,pji_attribute7
,pji_attribute8
,pji_attribute9
,pji_attribute10
,pji_attribute11
,pji_attribute12
,pji_attribute13
,pji_attribute14
,pji_attribute15
,pji_attribute16
,pji_attribute17
,pji_attribute18
,pji_attribute19
,pji_attribute20
,pji_attribute21
,pji_attribute22
,pji_attribute23
,pji_attribute24
,pji_attribute25
,pji_attribute26
,pji_attribute27
,pji_attribute28
,pji_attribute29
,pji_attribute30
,pji_information_category
,pji_information1
,pji_information2
,pji_information3
,pji_information4
,pji_information5
,pji_information6
,pji_information7
,pji_information8
,pji_information9
,pji_information10
,pji_information11
,pji_information12
,pji_information13
,pji_information14
,pji_information15
,pji_information16
,pji_information17
,pji_information18
,pji_information19
,pji_information20
,pji_information21
,pji_information22
,pji_information23
,pji_information24
,pji_information25
,pji_information26
,pji_information27
,pji_information28
,pji_information29
,pji_information30
,object_version_number
from per_prev_job_extra_info
where previous_job_extra_info_id = p_previous_job_extra_info_id
for update nowait;