Oracle Tutorial

Between Operator Examples

Example 1

Select *
From users_log u
Where u.log_date Between '01-OCT-2011' And '31-OCT-2011';

Example 2

Select *
From books b
Where b.book_id Not Between 100 and 300;


Example 3

Declare
v_id number := 5;
Begin
If v_id Between 5 And 10 Then
dbms_output.put_line('v_id is in the range');
End If;
End;