BETWEEN Operator in Oracle SQL Plus
The BETWEEN Operator is used in WHERE Clause and allows us to define a condition to retrieve values within a range.
BETWEEN Operator is used in WHERE Clause to
select a range of data between two values i.e. from one value to another value.
The value can be number, text and dates.
SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND
From the given table, we want to select the value by EmpId from BA0003 to
BA0007, we'll execute the following query :
SELECT * FROM EmpInfo WHERE EmpId BETWEEN
'BA0003' AND 'BA0007';
The output table will look like this :