[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
training_plan_cost_id
,tp_measurement_type_id
,training_plan_id
,booking_id
,event_id
,amount
,currency_code
,business_group_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
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,information_category
,tp_cost_information1
,tp_cost_information2
,tp_cost_information3
,tp_cost_information4
,tp_cost_information5
,tp_cost_information6
,tp_cost_information7
,tp_cost_information8
,tp_cost_information9
,tp_cost_information10
,tp_cost_information11
,tp_cost_information12
,tp_cost_information13
,tp_cost_information14
,tp_cost_information15
,tp_cost_information16
,tp_cost_information17
,tp_cost_information18
,tp_cost_information19
,tp_cost_information20
,tp_cost_information21
,tp_cost_information22
,tp_cost_information23
,tp_cost_information24
,tp_cost_information25
,tp_cost_information26
,tp_cost_information27
,tp_cost_information28
,tp_cost_information29
,tp_cost_information30
from ota_training_plan_costs
where training_plan_cost_id = p_training_plan_cost_id;
select
training_plan_cost_id
,tp_measurement_type_id
,training_plan_id
,booking_id
,event_id
,amount
,currency_code
,business_group_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
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,information_category
,tp_cost_information1
,tp_cost_information2
,tp_cost_information3
,tp_cost_information4
,tp_cost_information5
,tp_cost_information6
,tp_cost_information7
,tp_cost_information8
,tp_cost_information9
,tp_cost_information10
,tp_cost_information11
,tp_cost_information12
,tp_cost_information13
,tp_cost_information14
,tp_cost_information15
,tp_cost_information16
,tp_cost_information17
,tp_cost_information18
,tp_cost_information19
,tp_cost_information20
,tp_cost_information21
,tp_cost_information22
,tp_cost_information23
,tp_cost_information24
,tp_cost_information25
,tp_cost_information26
,tp_cost_information27
,tp_cost_information28
,tp_cost_information29
,tp_cost_information30
from ota_training_plan_costs
where training_plan_cost_id = p_training_plan_cost_id
for update nowait;