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