返回首页

gbase数据、南大通用产品文档:GBase8s%:

更新日期:2024年09月11日

EXECUTE FUNCTION task("modify space sp_sizes", "dbspace8", "20", "1.5");

| 1-URGENT
|

在内部FOR LOOP语句中的EXIT WHEN语句
DECLARE
v_employees employees%ROWTYPE;
CURSOR c1 is SELECT * FROM employees;
BEGIN
OPEN c1;
-- Fetch entire row into v_employees record:

GBase 8s PL/SQL手册
南大通用数据技术股份有限公司
- 55 -

<>
FOR i IN 1..10 LOOP
-- Process data here
FOR j IN 1..10 LOOP
FETCH c1 INTO v_employees;
EXIT outer_loop WHEN c1%NOTFOUND;
-- Process data here
END LOOP;
END LOOP outer_loop;
CLOSE c1;
END;