What is Like operator?

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.

- It is used in a WHERE clause to search for a specified pattern in a column.

- It is used to match or test a conditional term using a "wildcard search".

- There are two operators that are used for searching the "%" and "_".

- The percent matching(%) will match any group of characters and can stand for zero or more characters with no upper limit. The % sign can be added at the beginning or at the end of the term or on both of them.

- The underscore matching (_) is selective and matches any single character.

Example :The query below will display results of student names starting with A.
SELECT stud_name FROM dept WHERE student_name LIKE 'A%';
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...
Oracle union, intersect and minus
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.......
Post your comment