[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
previous_job_id
,previous_employer_id
,start_date
,end_date
,period_years
,period_days
,job_name
,employment_category
,description
,pjo_attribute_category
,pjo_attribute1
,pjo_attribute2
,pjo_attribute3
,pjo_attribute4
,pjo_attribute5
,pjo_attribute6
,pjo_attribute7
,pjo_attribute8
,pjo_attribute9
,pjo_attribute10
,pjo_attribute11
,pjo_attribute12
,pjo_attribute13
,pjo_attribute14
,pjo_attribute15
,pjo_attribute16
,pjo_attribute17
,pjo_attribute18
,pjo_attribute19
,pjo_attribute20
,pjo_attribute21
,pjo_attribute22
,pjo_attribute23
,pjo_attribute24
,pjo_attribute25
,pjo_attribute26
,pjo_attribute27
,pjo_attribute28
,pjo_attribute29
,pjo_attribute30
,pjo_information_category
,pjo_information1
,pjo_information2
,pjo_information3
,pjo_information4
,pjo_information5
,pjo_information6
,pjo_information7
,pjo_information8
,pjo_information9
,pjo_information10
,pjo_information11
,pjo_information12
,pjo_information13
,pjo_information14
,pjo_information15
,pjo_information16
,pjo_information17
,pjo_information18
,pjo_information19
,pjo_information20
,pjo_information21
,pjo_information22
,pjo_information23
,pjo_information24
,pjo_information25
,pjo_information26
,pjo_information27
,pjo_information28
,pjo_information29
,pjo_information30
,object_version_number
,all_assignments
,period_months
from per_previous_jobs
where previous_job_id = p_previous_job_id;
select
previous_job_id
,previous_employer_id
,start_date
,end_date
,period_years
,period_days
,job_name
,employment_category
,description
,pjo_attribute_category
,pjo_attribute1
,pjo_attribute2
,pjo_attribute3
,pjo_attribute4
,pjo_attribute5
,pjo_attribute6
,pjo_attribute7
,pjo_attribute8
,pjo_attribute9
,pjo_attribute10
,pjo_attribute11
,pjo_attribute12
,pjo_attribute13
,pjo_attribute14
,pjo_attribute15
,pjo_attribute16
,pjo_attribute17
,pjo_attribute18
,pjo_attribute19
,pjo_attribute20
,pjo_attribute21
,pjo_attribute22
,pjo_attribute23
,pjo_attribute24
,pjo_attribute25
,pjo_attribute26
,pjo_attribute27
,pjo_attribute28
,pjo_attribute29
,pjo_attribute30
,pjo_information_category
,pjo_information1
,pjo_information2
,pjo_information3
,pjo_information4
,pjo_information5
,pjo_information6
,pjo_information7
,pjo_information8
,pjo_information9
,pjo_information10
,pjo_information11
,pjo_information12
,pjo_information13
,pjo_information14
,pjo_information15
,pjo_information16
,pjo_information17
,pjo_information18
,pjo_information19
,pjo_information20
,pjo_information21
,pjo_information22
,pjo_information23
,pjo_information24
,pjo_information25
,pjo_information26
,pjo_information27
,pjo_information28
,pjo_information29
,pjo_information30
,object_version_number
,all_assignments
,period_months
from per_previous_jobs
where previous_job_id = p_previous_job_id
for update nowait;