declare
l_day DATE;
begin
l_day := to_date('&dd', 'DD-MON-YYYY');
while l_day < to_date('&mm','DD-MON-YYYY') loop
if to_char(to_date(l_day), 'DAY') like 'SUNDAY%' then
dbms_output.put_line(l_day);
end if;
l_day := l_day + 1;
end loop;
end;
|
Results 1 to 3 of 3
Threaded View
|
Click Here to Expand Forum to Full Width |