User Tools

Site Tools


kurs:pipelined_function_mit_oracle_data_type

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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] (current)
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;
   ​   ​
kurs/pipelined_function_mit_oracle_data_type.txt · Last modified: 2015/04/23 13:10 by mh