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
代码如下:select line,text from dba_source where name=’PRO_E_F_ORDER_STAT’; select object_name,object_type from dba_objects where object_type=’PROCEDURE’;
您可能感兴趣的文章:Oracle存储过程游标用法分析oracle存储过程常用的技巧（详）asp.net中调用oracle存储过程的方法C#调用Oracl
