by Dexter | Dec 5, 2020 | Oracle SQL
NULL is a special value in Oracle that represents absence of value in a field. In the world of relational databases, A Null means: A field in column which has not been assigned any value.NULL value represents empty value, i.e, no value was given.NULL is not equal to...
by Dexter | Dec 5, 2020 | Oracle SQL
If we want to retrieve some data by matching some text patterns, then we can use the LIKE operator. Suppose, we want to find all the employees whose first name starts with letter ‘F’ then we can use LIKE operator. We can also find patterns, like names...
by Dexter | Dec 5, 2020 | Oracle SQL
The Oracle IN operator is used to check whether the column value matches any of the values in list, that we give. We can also use a subquery instead of manually giving the list of values to compare against. The syntax of Oracle IN operator is as follows: SELECT...
by Dexter | Dec 5, 2020 | Oracle SQL
If we want to filter rows based on values within a specific range then we use, BETWEEN operator. BETWEEN Operator is used with AND clause to specify a range of values. Here’s the syntax for BETWEEN operator in Oracle: SELECT column_name FROM table_name WHERE...
by Dexter | Dec 5, 2020 | Oracle SQL
OR is a logical operator in Oracle that is used to combine two expressions and returns true if either one of the condition is true. The syntax for this Logical condition is as follows: expression1 OR expression2 It returns TRUE if either of the expressions are TRUE,...
by Dexter | Dec 5, 2020 | Oracle SQL
AND is a logical condition in Oracle and its usage is the same as in English language. This logical condition is used to combine two expressions. The syntax for this Logical condition is as follows: expression1 AND expression2 It returns TRUE if both the expressions...