-
半离
发布于 2009-06-23 18:57
-
收藏
复制代码 代码如下: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; E..