Oracle operators questions and answers

Unary operators:- Operates on one operand. Binary:- Operates on two operands.
IN operator in a query allows you to have multiple values in a WHERE clause.........
LIKE in oracle enables the user to search for a string of the matching type. “%” is used as a wild card in the query.
IS NULL operator is usually used to check if a columns value is NULL or not.............
Oracle deals with Null values using NVL function. The function replaces the NULL value in the given column with the value provide to it...
Oracle union, intersect and minus - UNION: The UNION operator is used to combine the result-set of two or more SELECT statements Tables of both the select statement must have the same number of columns with similar data types. It eliminates duplicates.......