Oracle与Sql Server写SQL的区别

SQL SERVER 中TOP 语句在ORACLE SQL如何写?

SQL SERVER:
SELECT TOP 1 * FROM USERINFO ORDER BY CREATEDATE ASC

ORACLE:
SELECT * FROM USERINFO WHERE ROWNUM<2 ORDER BY CREATEDATE ASC

 

SQL SERVER与ORACLE SQL语句参数区别？

SQL SERVER使用关键字 @
ORACLE 使用关键字:

SQL SERVER:
SELECT * FROM USERINFO WHERE NAME=@NAME

ORACLE:
SELECT * FROM USERINFO WHERE NAME=:NAME