An operator is reserved word that manipulates individual data items and returns a result. The data items are called operands or arguments.
Operators are represented by special characters.For example, the Addition operator is represented by plus (+) and subtraction operator represented by minus (-) etc. There are two general classes of operators:
1. Unary operators.
The Unary operators operate on a single operand.
+ (Positive) Numeric value is positive.
– (Negative) Numeric value is negative.
~ (Bitwise NOT) Returns the ones complement of the number.
The binary operators operate on two operands.
Oracle Lite SQL also supports set operators.
Set operators combine sets of rows returned by queries, instead of individual data items. All set operators have equal precedence.
- UNION ALL
Types of operators.
Click here Other operators.