|
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.......
|
