declare
p_date varchar2(32);
p_nextdate varchar2(32);
p_lastdate varchar2(32);
p_date_date date;
p_nextdate_date date;
begin
p_date :='2013-05-01';
p_lastdate:='2013-05-31';
p_date_date := to_date(p_date,'yyyy-mm-dd');
loop
dbms_output.put_line(p_date);
select trunc(p_date_date + 1) into p_nextdate_date from dual;
p_date_date:=p_nextdate_date;
p_date := to_char(p_nextdate_date,'yyyy-mm-dd');
if(p_date>p_lastdate) then
exit;
end if;
end loop;
end;
p_date varchar2(32);
p_nextdate varchar2(32);
p_lastdate varchar2(32);
p_date_date date;
p_nextdate_date date;
begin
p_date :='2013-05-01';
p_lastdate:='2013-05-31';
p_date_date := to_date(p_date,'yyyy-mm-dd');
loop
dbms_output.put_line(p_date);
select trunc(p_date_date + 1) into p_nextdate_date from dual;
p_date_date:=p_nextdate_date;
p_date := to_char(p_nextdate_date,'yyyy-mm-dd');
if(p_date>p_lastdate) then
exit;
end if;
end loop;
end;