Oracle Vs Microsoft SQL Server Functions

Arithmetic Operators

Oracle	Microsoft SQL Server
+	+
-	-
*	*
/	/

Comparison Operators

Oracle	Microsoft SQL Server
=	=
>	>
<	<
>=	>=
<=	<=
<>, !=, ^=	<>
IS NOT NULL	IS NOT NULL
IS NULL	IS NULL

Pattern Matching

Oracle	Microsoft SQL Server
LIKE	LIKE
NOT LIKE	NOT LIKE

Group Functions

Oracle	Microsoft SQL Server
AVG	AVG
COUNT	COUNT
MAX	MAX
MIN	MIN
SUM	SUM