ORACLE BETWEEN

In Oracle, BETWEEN is used to get the values from given range in select, insert, delete or update statement

Syntax

Expression BETWEEN value1 AND value2;  

Parameters

Expression: column name

value1 and value2: values for range

Table:

Example 1

select id, name, age from table1 where age between 20 AND 28