CREATE FUNCTION F_YEAR_ALL_DAYS(THE_DAY VARCHAR(10)) RETURNS TABLE(ROWID INTEGER,DETAIL_DATE DATE)SPECIFIC SQL071218171441700LANGUAGE SQLNOT DETERMINISTICREADS SQL DATASTATIC DISPATCHCALLED ON NULL INPUTEXTERNAL ACTIONINHERIT SPECIAL REGISTERSp1:begin atomicDECLARE v_first_day VARCHAR(10);SET v_first_day = substr(THE_DAY,1,4)||'-01'||'-01';RETURNselect T.rowid,T.detail_datefrom (select a.rowid,a.detail_datefrom (select ROW_NUMBER() over() as rowid, (DATE(v_first_day) + ( ROW_NUMBER() over() - 1) day ) as detail_datefrom table_a) awhere year(a.detail_date) = year(v_first_day)) as T;end p1@