SELECT * FROM dt_tb WHERE month(dt) between '02' and '08';
dt_tb
for more details please refer : http://www.plus2net.com/sql_tutorial/between-date.php
How to display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000 in Oracle?
suppose if i give '12345'
output should be:
1 12 123 1234 12345 1234 123 12 1