CREATE PROCEDURE Concat_names()
LANGUAGE SQL
BEGIN -- Note: implicit cursor manipulation
DECLARE fullname CHAR(140);
FOR v1 AS SELECT STUDENT_ID,STUDENT_NAME
FROM student
DO
SET fullname = v1.STUDENT_ID || ', ' || v1.STUDENT_NAME;
INSERT INTO student VALUES (9,fullname);
END FOR;
END;