Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Operators, 3 of 6
You can use an arithmetic operator in an expression to negate, add, subtract, multiply, and divide numeric values. The result of the operation is also a numeric value. Some of these operators are also used in date arithmetic. Table 3-2 lists arithmetic operators.
Do not use two consecutive minus signs (--) in arithmetic expressions to indicate double negation or the subtraction of a negative value. The characters -- are used to begin comments within SQL statements. You should separate consecutive minus signs with a space or a parenthesis.
See Also:
"Comments" for more information on comments within SQL statements |
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|