文章列表
1.部分SQL语句差异
（1）SQL：select top 10 * from table
ORA: select * from table where rownum<11
（2）SQL：Select * from t1 join t2 on t1.c1=t2.c1
ORA: select * from t1,t2 where t1.c1=t2.c1
（3）select * from t1 left join t2 on t1.c1=t2.c1
ORA: select * from t1,t2 where t1.c1=t2.c1(+)
（4）SQL：sele ...
- 2009-06-01 15:31
- 浏览 1431
- 评论(0)