The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
posting_content_id
,display_manager_info
,display_recruiter_info
,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
,ipc_information_category
,ipc_information1
,ipc_information2
,ipc_information3
,ipc_information4
,ipc_information5
,ipc_information6
,ipc_information7
,ipc_information8
,ipc_information9
,ipc_information10
,ipc_information11
,ipc_information12
,ipc_information13
,ipc_information14
,ipc_information15
,ipc_information16
,ipc_information17
,ipc_information18
,ipc_information19
,ipc_information20
,ipc_information21
,ipc_information22
,ipc_information23
,ipc_information24
,ipc_information25
,ipc_information26
,ipc_information27
,ipc_information28
,ipc_information29
,ipc_information30
,object_version_number
,date_approved
,recruiter_full_name
,recruiter_email
,recruiter_work_telephone
,manager_full_name
,manager_email
,manager_work_telephone
from irc_posting_contents
where posting_content_id = p_posting_content_id;
select
posting_content_id
,display_manager_info
,display_recruiter_info
,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
,ipc_information_category
,ipc_information1
,ipc_information2
,ipc_information3
,ipc_information4
,ipc_information5
,ipc_information6
,ipc_information7
,ipc_information8
,ipc_information9
,ipc_information10
,ipc_information11
,ipc_information12
,ipc_information13
,ipc_information14
,ipc_information15
,ipc_information16
,ipc_information17
,ipc_information18
,ipc_information19
,ipc_information20
,ipc_information21
,ipc_information22
,ipc_information23
,ipc_information24
,ipc_information25
,ipc_information26
,ipc_information27
,ipc_information28
,ipc_information29
,ipc_information30
,object_version_number
,date_approved
,recruiter_full_name
,recruiter_email
,recruiter_work_telephone
,manager_full_name
,manager_email
,manager_work_telephone
from irc_posting_contents
where posting_content_id = p_posting_content_id
for update nowait;