chapter12ex1packagebody.sql

来自「数据库学习的绝好例子简单的数据库经典入门」· SQL 代码 · 共 13 行

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;