usp_selectmanagername.sql

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

CREATE OR REPLACE PROCEDURE usp_SelectManagerName
(
   inManagerID      IN  CHAR,
   outManagerName   OUT VARCHAR2
)
AS

BEGIN
   SELECT FirstName || ' ' || LastName INTO outManagerName
   FROM Users
   WHERE UserID = inManagerID;
END;