Conditional operators in Oracle queries

[Balamani]

I want to know about the SQL queries and What is the process to fire it on database and If we want to access selected data that can fit according to my need. What are the types of operators that can be used in the queries of Oracle database. I wanted to know specially about ANY and ALL operator with their syntax and explanation. Can you help me please..

[Praetor]

An operator takes some arguments and after manipulation, it returns a result. Operators are indicated by some special characters or keywords.

There are so many operators are being used to fetch the data from database.They are categorized into different segments :

1. Arithmetic operators
- Addition
- Subtraction
- Multiplication
- Division
2. Assignment operator
3. Association operator (=>)
4. Concatenation operators (||)
5. Date Operators
- Addition
- Subtraction
6. Hierarchical Query Operators (Connect,CONNECT BY, CONNECT BY PRIOR, and CONNECT BY ROOT)
7. Set operators
- Intersect
- Minus
- Union all
- Union

[Katty]

Some conditional operators are explained here with the suitable example which are commonly used in oracle to access the records from database.

Conditional operators:

The operators that are being used to access the selected data ,we perform the conditional operators in our queries.

1. Not equal (<>) operator
This operator is basically used as name suggested Not equal (<>)operator

Example: SELECT * FROM employee WHERE id <> 2;

This query will ignore the 2nd record of employee table.

2. Greater than operator:
SELECT id, first_name FROM employee WHERE id > 3;
This query will select the record of only those employee from employees table whose "id" is greater than 3.

3. Greater than equal to :
select id, first_name from employee where id >= 3;

This query will select only those records whose employee "id" is greater than or equal to 3.

In this series we can use these operators in different ways. Like <,<= but not =>,=< like that .It follows some rules.

[kelfro]

ANY:It Compares a value to each value in the list of different values. It occur FALSE if the query doesn't response any result.

scott@Mine> select empname, salary
from emp
where salary > ANY (1600, 2999);

ALL :It Compares a value to every value in a list. It occur TRUE if the query doesn't return rows.

scott@Mine> select empname, salary
from emp
where salary > ALL (1600, 2999);