[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
qualification_id,
business_group_id,
object_version_number,
person_id,
title,
grade_attained,
status,
awarded_date,
fee,
fee_currency,
training_completed_amount,
reimbursement_arrangements,
training_completed_units,
total_training_amount,
start_date,
end_date,
license_number,
expiry_date,
license_restrictions,
projected_completion_date,
awarding_body,
tuition_method,
group_ranking,
comments,
qualification_type_id,
attendance_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
qua_information_category,
qua_information1,
qua_information2,
qua_information3,
qua_information4,
qua_information5,
qua_information6,
qua_information7,
qua_information8,
qua_information9,
qua_information10,
qua_information11,
qua_information12,
qua_information13,
qua_information14,
qua_information15,
qua_information16,
qua_information17,
qua_information18,
qua_information19,
qua_information20,
professional_body_name,
membership_number,
membership_category,
subscription_payment_method,
party_id
from per_qualifications
where qualification_id = p_qualification_id;
select qualification_id,
business_group_id,
object_version_number,
person_id,
title,
grade_attained,
status,
awarded_date,
fee,
fee_currency,
training_completed_amount,
reimbursement_arrangements,
training_completed_units,
total_training_amount,
start_date,
end_date,
license_number,
expiry_date,
license_restrictions,
projected_completion_date,
awarding_body,
tuition_method,
group_ranking,
comments,
qualification_type_id,
attendance_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
qua_information_category,
qua_information1,
qua_information2,
qua_information3,
qua_information4,
qua_information5,
qua_information6,
qua_information7,
qua_information8,
qua_information9,
qua_information10,
qua_information11,
qua_information12,
qua_information13,
qua_information14,
qua_information15,
qua_information16,
qua_information17,
qua_information18,
qua_information19,
qua_information20,
professional_body_name,
membership_number,
membership_category,
subscription_payment_method,
party_id
from per_qualifications
where qualification_id = p_qualification_id
for update nowait;