POQ_QUESTION_STRUCTURE_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: POQ
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ROOT_QUESTION_ID QUESTION_ID BRANCH_LEVEL MAPPED_TO_PREREQ_QUESTION_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT DISTINCT CONNECT_BY_ROOT(Q.QUESTION_ID) ROOT_QUESTION_ID, Q.QUESTION_ID, LEVEL BRANCH_LEVEL, Q.MAPPED_TO_PREREQ_QUESTION_ID FROM POQ_QUESTIONS_VL Q, POQ_QUES_ACC_RESPONSES_VL ACC, POQ_QUESTION_BRANCHES BRNCH WHERE Q.QUESTION_ID = ACC.QUESTION_ID(+) AND ACC.ACC_RESPONSE_ID =BRNCH.ACC_RESPONSE_ID(+) CONNECT BY PRIOR BRNCH.BRANCH_TO_QUESTION_ID= Q.QUESTION_ID |