usp_insertgroup.sql

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

CREATE OR REPLACE PROCEDURE usp_InsertGroup
(
   inGroupID            CHAR,
   inGroupName          VARCHAR2,
   inGroupDescription   CLOB
)
AS
BEGIN
INSERT INTO Groups 
   (GroupID, GroupName, GroupDescription, LastUpdateDate)
   VALUES(inGroupID, inGroupName, inGroupDescription, SYSDATE);
END;