What is IN operator?

What is IN operator?

- IN operator in a query allows you to have multiple values in a WHERE clause.

- It is used to compare a value to a list of the literal values that have been specified.

- It is used to test whether the value is there in the list provided or not.

- This conditional operator can also be rewritten by using the compound conditions by using the equal operator or combining it with the OR.

- It is easier to read when the testing is to be done for more than two or three values.

Example :To return records of employees staying in Pune and Mumbai.
Select * from employee
Where employee_location IN ('Pune', 'Mumbai');
What is Like operator?
LIKE in oracle enables the user to search for a string of the matching type. “%” is used as a wild card in the query.
Define Is Null operator
IS NULL operator is usually used to check if a columns value is NULL or not.............
What is NVL() function?
Oracle deals with Null values using NVL function. The function replaces the NULL value in the given column with the value provide to it...
Post your comment