server语言转成oracle语言 - Oracle / 开发

本人只学过oracle，现在做练习，里面有一段server语句不知道怎么理解，请高手帮忙把这段代码改成oracle的代码，谢谢了



create procedure GetScheduleGivenDay @GivenDay datetime
as

select  
  task.title,
  task.detail,
  task.begintime,
  task.notifytime,
  task.neednotify,
  task.finished,
  tasktype.typetitle,
  priority.prioritytitle
from tasktype
  INNER JOIN task ON Task.Type.TaskType_ID=task.type
  INNER JOIN priority ON task.priority=priority.priority_ID
where  
  (DAY(@GivenDay)=DAY(task.BeginTime))
  AND
  (MONTH(@GivenDay)=MONTH(task.BeginTime))
  AND
  (YEAR(@GivenDay)=YEAR(task.BeginTime))
RETURN
GO

---

如果转SQL版倒还行,转Oracle去Oracle如何.

---

这个应该去Oracle专区问问
还有你的说明你这段代码是干啥的，别人才好帮你。

---

就在那边问了。他们写了代码也不行，我才过来这里问的

---

这个难道有问题

CREATE OR REPLACE PROCEDURE GetScheduleGivenDay (GivenDay datetime)
as
begin
select  
  task.title,
  task.detail,
  task.begintime,
  task.notifytime,
  task.neednotify,
  task.finished,
  tasktype.typetitle,
  priority.prioritytitle
from tasktype
  INNER JOIN task ON Task.Type.TaskType_I