Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - The difference between sqlserver and oracle sql syntax
The difference between sqlserver and oracle sql syntax
Sqlserver and oracle correspond to two optimized versions of sql, namely T-SQL and PL-SQL.

Standard sql syntax is compatible, such as the syntax of subquery, and the difference is only the way of using functions.

Isnull and nvl

Row_number() over and rownumber ()

Ceiling and ceiling

Log and ln

Power of sum of squares

+and ||

Substring and substring

Lens and length

Get date and system date

The above and so on are all functions with the same function.

Of course, there are also cases where the parameter order of the same name function is different, so I won't list them one by one.