CREATE PROCEDURE Concat_names()LANGUAGE SQLBEGIN -- 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.S...
显示全部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;
收起