I want to use some variables in Oracle SQL Developer - i know how to use them with MS SQL and want to do something similar to the below
Declare @startDate datetime,
select @startDate = '01/01/2015',
@endDate = '03/01/2015'
In my Oracle SQL Statment i want to use the variables in this piece of code:
and (call_dt >= to_date('3/1/2015','mm/dd/yyyy') and call_dt <= to_date('3/28/2015','mm/dd/yyyy'))