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רÇøÎÊÎÊ
»¹ÓÐÄãµÄ˵Ã÷ÄãÕâ¶Î´úÂëÊǸÉɶµÄ£¬±ðÈ˲źðïÄã¡£

---

¾ÍÔÚÄDZßÎÊÁË¡£ËûÃÇдÁË´úÂëÒ²²»ÐУ¬ÎҲŹýÀ´ÕâÀïÎʵÄ

---

Õâ¸öÄѵÀÓÐÎÊÌâ

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