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
PDF 英文版 1068页 DB2开发者指南,非常全面、详尽的一本参考书。 db2开发者必看,对于其他数据库系统也有非常高的参考价值 DB2 Developer's Guide, Fourth Edition is a new and updated edition that includes the hot new features in DB2 version 6 for OS/390. Not only do the authors explain the changes, but th
再写一个存储过程时, 用到了如下sql语句 代码如下: SELECT MAX(RE_DATE) INTO V_RE_DATE FROM T_RECORDING WHERE ID =’100010010102′ 按理说,根据这个条件查询的结果应该为sqlcode=1403 ,但是奇怪的是如下sql异常却捕获不到: 代码如下: EXCEPTION WHEN NO_DATA_FOUND THEN NULL; WHEN OTHERS THEN ERR_CODE :=-2000; ERR_MSG :