variable rundate varchar2(15); execute :rundate :=to_char(sysdate); variable Month1 varchar2(15); execute :Month1 :=add_months(:rundate,-3);
first
last day
SELECT
variable Month1 varchar2(15); execute :Month1 :=to_char(add_months(:rundate,-3),'MON-DD');
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)