SELECT olf.name folder_name,
olo.learning_object_id,
olo.name learning_objects,
ot.test_id,
ots.test_section_id,
ots.name section_name,
oqb.question_bank_id,
oqb.name question_bank,
oqb.start_date_active question_bank_active_date,
oq.text question_text
FROM ota_lo_folders olf,
ota_learning_objects olo,
ota_tests ot,
ota_test_sections ots,
ota_question_banks oqb,
ota_qbank_questions oqbq,
ota_questions oq
WHERE olf.business_group_id = :l_business_group_id
AND olf.folder_id = olo.folder_id
AND ot.test_id = olo.test_id
AND ots.test_id = ot.test_id
AND oqb.folder_id = olf.folder_id
AND oqbq.question_bank_id = oqb.question_bank_id
AND oq.question_id = oqbq.question_id
No comments:
Post a Comment