Hi Everyone,
Please see the below code and help me insert these string values. How can I trap that string value and insert it?
DECLARE
BEGIN
for i in (SELECT STRAGG(Q.QUESTION_CODE)
FROM QUESTION Q , TEST_CODE_CONVERSION TC
WHERE Q.ACTIVE_YN = 'Y'
AND Q.TEST_ID = TC.EAST_TEST_ID
GROUP BY Q.TEST_ID)
LOOP
INSERT INTO TEST_CODE_CONVERSION (QCODE_FOR_WEST_TEST_ID)
VALUES (___________) ;
dbms_output.put_line('1 row inserted');
END LOOP;
End;
Regards,
BS2012.