This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
kurs:pipelined_function_mit_oracle_data_type [2015/04/23 13:02] mh |
kurs:pipelined_function_mit_oracle_data_type [2015/04/23 13:10] mh |
||
---|---|---|---|
Line 6: | Line 6: | ||
GET_DAYS_OF_MONTH (p_year number, p_month number) | GET_DAYS_OF_MONTH (p_year number, p_month number) | ||
RETURN t_date pipelined AS | RETURN t_date pipelined AS | ||
- | v_date_start date; | + | v_date_last date; |
v_date date; | v_date date; | ||
BEGIN | BEGIN | ||
v_date := to_date(p_year||lpad(p_month, 2, 0)||'01', 'yyyymmdd'); | v_date := to_date(p_year||lpad(p_month, 2, 0)||'01', 'yyyymmdd'); | ||
- | | + | |
- | while v_date < last_day(v_date) loop | + | v_date_last := last_day(v_date); |
- | -- v_date := v_date + 1; | + | while v_date <= v_date_last loop |
- | v_date := v_date + to_dsinterval('1 00:00:00'); | + | -- v_date := v_date + 1; |
pipe row(v_date); | pipe row(v_date); | ||
+ | v_date := v_date + to_dsinterval('1 00:00:00'); | ||
end loop; | end loop; | ||
| |