What are various Oracle Operator?
Different operators :Unary operators:- Operates on one operand.
Binary:- Operates on two operands.
Arithmetic operators:- Used to perform basic arithmetic operations like addition, subtraction etc. they are listed below:
+ - - Denotes positive or negative expression. They are unary operators.
*/- Denotes multiplication or division. They are binary operators.
||- Concatenates strings
=, !=. <, >, <=, >= are all comparison operators.
OR, AND, NOT are all logical operators
Example:SELECT * FROM emp
WHERE job = 'CLERK'
AND deptno = 10;
