摘要:
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 阅读全文