Wednesday, July 16, 2008

Types of Operators in Oracle

In oracle an operator manipulates data items and return a result after manipulation. The data items on which it operates are called operands. Based on the operator function it can be divided into following types.

1)User-Defined Operators: Discussed in

2)Arithmetic Operators: Discussed in Arithmatic Operators

3)Concatenation Operator: Discussed in Concatenation Operator.

4)Hierarchical Query Operators:
Discussed in

5)Set Operators: Discussed in

6)Multiset Operators: Discussed in

An operator can appear before an operand, after an operand or between operands.

No comments:

Post a Comment