数字

加法。

SELECT 1 + 2 AS result FROM DUAL;

RESULT
3

SELECT 0.1 + 0.2 AS result FROM DUAL;

RESULT
.3

减法。

SELECT 7 - 2 AS result FROM DUAL;

RESULT
5

SELECT 0.7 - 0.2 AS result FROM DUAL;

RESULT
.5

乘法。

SELECT 3 * 4 AS result FROM DUAL;

RESULT
12

SELECT 0.3 * 0.4 AS result FROM DUAL;

RESULT
.12

除法。

SELECT 8 / 2 AS result FROM DUAL;

RESULT
4

SELECT 7 / 2 AS result FROM DUAL;

RESULT
3.5

取余。

SELECT MOD(8, 2) AS result FROM DUAL;

RESULT
0

SELECT MOD(7, 2) AS result FROM DUAL;

RESULT
1