我这篇博文是通过具体的sql来讲解游标、存储过程的概念以及用法,在这里提醒一下:以下贴出的SQL语句都只是在DB2数据库中验证过了,可能在SQLServer或Oracle中会有些细微的差别,请了解。
以下是建表语句:--建表语句
CREATE TABLE STUDENT (
STU_ID VARCHAR(32) NOT NULL,
STU_NAME VARCHAR(20),
STU_SEX CHARACTER(1),
PRIMARY KEY(STU_ID)
);
CREATE TABLE STUDENT_TEMP (
STU_ID VARCHAR(32) NOT NULL,
STU_NAME VARCHAR(20),
STU_SEX CHARACTER(1),
PRIMARY KEY(STU_ID)
);
--初始sql
delete from STUDENT;
INSERT INTO STUDENT(STU_ID, STU_NAME, STU_SEX) VALUES('200811001', '李志信', '0');
INSERT INTO STUDENT(STU_ID, STU_NAME, STU_SEX) VALUES('200811002', '李斌', '1');
INSERT INTO STUDENT(STU_ID, STU_NAME, STU_SEX) VALUES('200811003', '李宽义', '0');
通过上述sql可以看出我创建了2个表:STUDENT(学生表)、STUDENT_TEMP (学生_临时表)&