[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
medical_assessment_id
,mea.person_id
,examiner_name
,mea.organization_id
,consultation_date
,consultation_type
,incident_id
,consultation_result
,disability_id
,next_consultation_date
,description
,mea.attribute_category
,mea.attribute1
,mea.attribute2
,mea.attribute3
,mea.attribute4
,mea.attribute5
,mea.attribute6
,mea.attribute7
,mea.attribute8
,mea.attribute9
,mea.attribute10
,mea.attribute11
,mea.attribute12
,mea.attribute13
,mea.attribute14
,mea.attribute15
,mea.attribute16
,mea.attribute17
,mea.attribute18
,mea.attribute19
,mea.attribute20
,mea.attribute21
,mea.attribute22
,mea.attribute23
,mea.attribute24
,mea.attribute25
,mea.attribute26
,mea.attribute27
,mea.attribute28
,mea.attribute29
,mea.attribute30
,mea_information_category
,mea_information1
,mea_information2
,mea_information3
,mea_information4
,mea_information5
,mea_information6
,mea_information7
,mea_information8
,mea_information9
,mea_information10
,mea_information11
,mea_information12
,mea_information13
,mea_information14
,mea_information15
,mea_information16
,mea_information17
,mea_information18
,mea_information19
,mea_information20
,mea_information21
,mea_information22
,mea_information23
,mea_information24
,mea_information25
,mea_information26
,mea_information27
,mea_information28
,mea_information29
,mea_information30
,mea.object_version_number
from per_medical_assessments mea
where medical_assessment_id = p_medical_assessment_id;
select
medical_assessment_id
,person_id
,examiner_name
,organization_id
,consultation_date
,consultation_type
,incident_id
,consultation_result
,disability_id
,next_consultation_date
,description
,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
,mea_information_category
,mea_information1
,mea_information2
,mea_information3
,mea_information4
,mea_information5
,mea_information6
,mea_information7
,mea_information8
,mea_information9
,mea_information10
,mea_information11
,mea_information12
,mea_information13
,mea_information14
,mea_information15
,mea_information16
,mea_information17
,mea_information18
,mea_information19
,mea_information20
,mea_information21
,mea_information22
,mea_information23
,mea_information24
,mea_information25
,mea_information26
,mea_information27
,mea_information28
,mea_information29
,mea_information30
,object_version_number
from per_medical_assessments
where medical_assessment_id = p_medical_assessment_id
for update nowait;