写一个函数,实现输入一个年份,查询出对应的天数
------解决方案--------------------
create or replace function countdaysofyear(myear number) return int is
days number;
begin
select (to_date(myear
------解决方案--------------------
'-12-31', 'yyyy-mm-dd') -
to_date(myear
------解决方案--------------------
'-1-1', 'yyyy-mm-dd') + 1)
into days
from dual;
return days;
end;
select countdaysofyear(2014) from dual;

select countdaysofyear(2008) from dual;
