The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
recruiting_site_id
,date_from
,date_to
,posting_username
,posting_password
,internal
,external
,third_party
,posting_cost
,posting_cost_period
,posting_cost_currency
,stylesheet
,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
,object_version_number
,internal_name
,posting_impl_class
from irc_all_recruiting_sites
where recruiting_site_id = p_recruiting_site_id;
select
recruiting_site_id
,date_from
,date_to
,posting_username
,posting_password
,internal
,external
,third_party
,posting_cost
,posting_cost_period
,posting_cost_currency
,stylesheet
,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
,object_version_number
,internal_name
,posting_impl_class
from irc_all_recruiting_sites
where recruiting_site_id = p_recruiting_site_id
for update nowait;