groupspackagebody.sql

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

CREATE OR REPLACE PACKAGE BODY GroupsPackage 
AS
   PROCEDURE usp_SelectGroups (results_cursor OUT CURSOR_TYPE)
   AS
   BEGIN
   OPEN results_cursor FOR
   SELECT GroupID, GroupName, GroupDescription, LastUpdateDate
   FROM Groups
   ORDER BY GroupName;
   END;
END;