您现在的位置是：网站首页> 编程资料编程资料

Oracle 数据使用游标_oracle_

2023-05-27 421人已围观

简介 Oracle 数据使用游标_oracle_

create or replace 
PROCEDURE proceudre_name AS 
BEGIN 
DECLARE 
sPara VARCHAR(50); 
sPara2 VARCHAR(50); 
CURSOR c_cursor IS SELECT ID,Name FROM Temp_table; 
BEGIN 
OPEN c_cursor; 
LOOP 
FETCH c_cursor INTO sPara, sPara2; 
EXIT WHEN c_cursor%NOTFOUND; 
BEGIN 
--just do what you want. 
END; 
END LOOP; 
CLOSE c_cursor; 
END; 
END; 