实例解析：DB2中实现Oracle的相关功能

Oracle 可以这样实现﹕
Select * from user.bsempms where rownum<=n; 
DB2 可以这样实现﹕ 
Select * from db2admin.bsempms fetch first n rows only; 
另外也可以用 row_number() over() 去实现的;

Oracle 可以这样实现﹕ 
Select sysdate from dual; 
DB2 可以这样实现﹕ 
Select current timestamp from sysibm.sysdummy1;

Oracle 可以这样实现﹕ 
Select emp_no||emp_nam from bsempms; 
Select concat(emp_no,emp_nam) from bsempms; 
DB2 可以这样实现﹕ 
Select emp_no||emp_nam from db2admin.bsempms; 
select emp_no concat emp_nam from db2admin.bsempms;

Oracle 可以这样实现﹕ 
Select sysdate from dual; 
DB2 可以这样实现﹕ 
Select current timestamp from sysibm.sysdummy1;

Oracle可以这样实现﹕ Select a.* from bsempms a,bsdptms b where a.dpt_no=b.dpt_no; 
DB2 可以这样实现﹕ Select * from db2admin.bsempms inner join db2admin.bsdptms on
db2admin.bsempms.dpt_no=db2admin.bsdptms.dpt_no;

Select a.* from bsempms a,bsdptms b where a.dpt_no=b.dpt_no(+); 
Select a.* from bsempms a,bsdptms b wherea.dpt_no(+)=b.dpt_no; 
DB2 可以这样实现﹕ 
Select * from db2admin.bsempms right outer join db2admin.bsdptms 
on db2admin.bsempms.dpt_no=db2admin.bsdptms.dpt_no; 
Select * from db2admin.bsempms left outer join db2admin.bsdptms 
on db2admin.bsempms.dpt_no=db2admin.bsdptms.dpt_no; 
Select * from db2admin.bsempms full outer join db2admin.bsdptms 
on db2admin.bsempms.dpt_no=db2admin.bsdptms.dpt_no;

Oracle 可以这样实现﹕ 
SQL>@$PATH/filename.sql; 
DB2 可以这样实现﹕ 
db2 -tvf $PATH/filename.sql 文件中每行以 ; 结尾