oracl 和db2 常用语法比较: 1、取前N条记录 Oracle:Select * from TableName where rownum <= N; DB2:Select * from TableName fetch first N rows only; 2、取得系统日期 Oracle:Select sysdate from dual; DB2:Select current timestamp from sysibm.sysdummy1; 3、空值转换 Oracle:Select
mysql声明游标的方法:
1、声明变量和游标
declare result varchar(3000);
declare flag1 varchar(100);
DECLARE done INT DEFAULT FALSE;
declare cur1 CURSOR FOR SELECT flag from bmlx;
2、变量赋值
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
set result = '';
3、打开游标和