The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
subjects_taken_id,
start_date,
major,
subject_status,
subject,
grade_attained,
end_date,
qualification_id,
object_version_number,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
sub_information_category,
sub_information1,
sub_information2,
sub_information3,
sub_information4,
sub_information5,
sub_information6,
sub_information7,
sub_information8,
sub_information9,
sub_information10,
sub_information11,
sub_information12,
sub_information13,
sub_information14,
sub_information15,
sub_information16,
sub_information17,
sub_information18,
sub_information19,
sub_information20
from per_subjects_taken
where subjects_taken_id = p_subjects_taken_id;
select subjects_taken_id,
start_date,
major,
subject_status,
subject,
grade_attained,
end_date,
qualification_id,
object_version_number,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
sub_information_category,
sub_information1,
sub_information2,
sub_information3,
sub_information4,
sub_information5,
sub_information6,
sub_information7,
sub_information8,
sub_information9,
sub_information10,
sub_information11,
sub_information12,
sub_information13,
sub_information14,
sub_information15,
sub_information16,
sub_information17,
sub_information18,
sub_information19,
sub_information20
from per_subjects_taken
where subjects_taken_id = p_subjects_taken_id
for update nowait;