SQL Script with Constant

[saw15]

Working with a select statement, I only want to pull the last 2 years data. So in the where clause I currently use:

where insert_datetime >= trunc(sysdate - 730).

I would like to know.. if you can set a constant variable of CalcDate where CalcDate = trunc(sysdate - 730) and just reference this declared variable within the where clause. Example... where insert_datetime >= CalcDate etc.

Help is appreciated.

Thanks

 

[vijaychin]

Yes you can

 

[saw15]

I am actually looking for an example of how its done, or the keyword used to define the variable etc if you have one.

Or any pointers in the right direction.

 

[vijaychin]

CalcDate date := trunc(sysdate-730);

or

CalcDate date;

in DECLARE section and ClacDate := trunc(sysdate-730) after BEGIN.