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
drop PROCEDURE if exists my_procedure;
create PROCEDURE my_procedure()
BEGIN
declare my_sqll varchar(500);
set my_sqll='select * from aa_list';
set ms=my_sqll;
PREPARE s1 from ms;
EXECUTE s1;
deallocate prepare s1;
end;
