usp_updategroup.sql

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

CREATE OR REPLACE PROCEDURE usp_UpdateGroup
(
   inGroupName          VARCHAR2,
   inGroupDescription   CLOB,
   inGroupID            CHAR
)
AS
BEGIN
UPDATE Groups 
SET GroupName = inGroupName, 
    GroupDescription = inGroupDescription, 
    LastUpdateDate = SYSDATE
WHERE GroupID = inGroupID;
END;