Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Aggregate function in for loop insert

BS2012May 15 2013 — edited May 15 2013
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2013
Added on May 15 2013
9 comments
393 views