Saturday, February 15, 2014

Traversing from Folder to Question Details

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