2009年7月13日
摘要: 1.部分SQL语句差异(1)SQL:select top 10 * from tableORA: select * from table where rownum<11(2)SQL:Select * from t1 join t2 on t1.c1=t2.c1ORA: select * from t1,t2 where t1.c1=t2.c1(3)select * from t1 left join t2 on t1.c1=t2.c1ORA: select * from t1,t2 where t1.c1=t2.c1(+)(4)SQL:select * from t1 right joi 阅读全文
posted @ 2009-07-13 22:18 heoo 阅读(9113) 评论(1) 推荐(0) 编辑