1You use the operators in any
2clause (except the From clause)
3 With Date and Timestamp - can only use addition and subtraction
4 Add (+), Subtract (-), Multiply (*), Divide (/)
1(Between) operator same as ">= <="
2For example:
3Select * From Employees Where salary Between 4000 AND 6000;
4
5(NOT) operator excluding given
6For example:
7Select last_name, job_id From Employees
8Where "Not" job_id = 'ABC';
9
10
11(IN) operator in sql like "OR" operator
12For example:
13Select * From employees
14Where department_id "IN" (60,90);
15
16
17(Like) Operator for partial searches using wildcard '%' and '_'
18For Example:
19Select * From Employees
20Where last_name LIKE '_a%';
21
22
23(Top N results)
24Select * From Employees Where ROWNUM <=5;
25
26
27(NVL) replaces NULL values with same type default
28value provided.
29For Example =
30Select NVL(commission_percentage, 0)
31From Employees;
32