usp_updateproject.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 17 行

CREATE OR REPLACE PROCEDURE usp_UpdateProject
(
   inProjectName          VARCHAR2,
   inProjectDescription   CLOB,
   inSequenceNumber       NUMBER,
   inProjectID            CHAR
)
AS
BEGIN
UPDATE Projects 
SET ProjectName = inProjectName, 
    ProjectDescription = inProjectDescription, 
    SequenceNumber = inSequenceNumber, 
    LastUpdateDate = SYSDATE
WHERE ProjectID = inProjectID;
END;