一个MySQL的存储过程,如下:
CREATE PROCEDURE `AddStock_detail`(IN aCard_b DECIMAL(16,0), IN aCard_e DECIMAL(16,0))
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
WHILE aCard_b <= aCard_e DO
Insert Into table (code, xm, bz)
Values(aCard_b, 'a', '0');
SET aCard_b = aCard_b + 1;
END WHILE;
END; 这个存储过程在oracle里该怎么写?
CREATE PROCEDURE `AddStock_detail`(IN aCard_b DECIMAL(16,0), IN aCard_e DECIMAL(16,0))
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
WHILE aCard_b <= aCard_e DO
Insert Into table (code, xm, bz)
Values(aCard_b, 'a', '0');
SET aCard_b = aCard_b + 1;
END WHILE;
END; 这个存储过程在oracle里该怎么写?
....
...
end loop;