Saturday, February 15, 2014

Query to Get Question Bank and corresponding questions stored @ Folder Level

SELECT olf.name folder_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_question_banks oqb,
       ota_qbank_questions oqbq,
       ota_questions oq
 WHERE     olf.business_group_id = :l_business_group_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