HRQ_ALL_QSTN_RESPONSES_V

Details

• Schema: FUSION

• Object owner: HRQ

• Object type: VIEW

Columns

Name
QSTNR_RESPONSE_ID QSTNR_QUESTION_ID BUSINESS_GROUP_ID QSTN_RESPONSE_ID ANSWER_TYPE ANSWER_TEXT ANSWER_CLOB ANSWER_ID

Query

SQL_Statement

SELECT t.QSTNR_RESPONSE_ID , t.QSTNR_QUESTION_ID , t.BUSINESS_GROUP_ID , t.QSTN_RESPONSE_ID , nvl2( a.ANSWER_ID || t.ANSWER_TEXT , nvl2( a.ANSWER_ID, 'RATING', 'ANSWER' ) , NULL ) AS ANSWER_TYPE , t.ANSWER_TEXT , t.ANSWER_CLOB , a.ANSWER_ID FROM HRQ_QSTN_RESPONSES t ,lateral( SELECT/*+ no_decorrelate */ TRIM(regexp_substr( t.answer_list, '[^,;]+', 1, level )) ANSWER_ID, level FROM (SELECT 1 FROM HRQ_QSTN_RESPONSES WHERE ROWNUM = 1) CONNECT BY regexp_substr( t.answer_list, '[^,;]+', 1, level ) IS NOT NULL )(+) a