更新日期:2024年09月11日
gbase> DELIMITER //
gbase> DROP PROCEDURE IF EXISTS docursor //
Query OK, 0 rows affected
gbase> CREATE PROCEDURE docursor()
BEGIN
DECLARE s_region VARCHAR(40);
DECLARE DONE INT DEFAULT(0);
DECLARE cur CURSOR FOR SELECT DISTINCT c_region FROM
ssbm.customer ORDER BY c_region LIMIT 6;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-09-15)
南大通用数据技术股份有限公司
1367
done = 1;
OPEN cur;
REPEAT
FETCH cur
INTO s_region;
IF NOT done THEN
SELECT s_region;
END IF;
UNTIL DONE END REPEAT;
CLOSE cur;
END //
Query OK, 0 rows affected
gbase> DELIMITER ;
gbase> CALL docursor();
+----------+
| s_region |
+----------+
| AFRICA
|
+----------+
1 row in set
+----------+
| s_region |
+----------+
| AMERICA
|
+----------+
1 row in set
+----------+
| s_region |
+----------+
| ASIA
|
+----------+
1 row in set
+----------+
| s_region |
+----------+
| EUROPE
|
+----------+
1 row in set
+-------------+
| s_region
|
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-09-15)
南大通用数据技术股份有限公司
1368
+-------------+
| MIDDLE EAST |
+-------------+
1 row in set
Query OK, 0 rows affected