Oracle/plsql calculating the number of days for a flat leap year

--Calculate the number of days for flat leapfunctionCREATE OR REPLACE FUNCTIONF_ping_run_nian (i_year Number   --define function Names                                            )                                        RETURN VARCHAR2    is  --defines the return (output) character typeV_tianshuvarchar2(5);--defining output (return) variablesBEGIN  SELECT   CaseMOD (I_year,4)--take the remainder divided by 4   when 0              --if it is 0, it is a leap year and should be 366 days     Then '366'      ELSE        '365'         --Otherwise it is 365 days        END      intoV_tianshu fromDual--Insert a value into a variable typeRETURN(V_tianshu);--output (return) value, remember to enclose the parentheses. END;

Oracle/plsql calculating the number of days for a flat leap year