chapter12ex1packagebody.sql

数据库学习的绝好例子简单的数据库经典入门

CREATE OR REPLACE PACKAGE BODY Chapter12Ex1Package
AS
   PROCEDURE usp_Chapter12Ex1 (results_cursor OUT CURSOR_TYPE)
   AS
   BEGIN
      OPEN results_cursor FOR
      SELECT FirstName || ' ' || LastName AS UserName, RoleName
      FROM Users
      JOIN Roles ON Users.RoleID = Roles.RoleID
      ORDER BY UserName;
   END;
END;