mysql 매개 변수 없는 저장 프로시져 만들기

▶ msql 

CREATE PROCEDURE GetCategories

AS

  SELECT CategoryID,CategoryName, [Description]

  FROM Categories 

  RETURN

▶ mysql 

CREATE PROCEDURE GetCategories()

BEGIN

   SELECT CategoryID, CategoryName, Description

   FROM Categories ;

END;

▶ oracle

CREATE OR REPLACE PACKAGE TYPES

AS

  TYPE CURSORTYPE IS REF CURSOR;

END;

CREATE or Replace PROCEDURE GetCategories

( CAT_CUR OUT TYPES.CURSORTYPE )

IS

BEGIN

   OPEN cat_cur FOR

   SELECT CategoryID, CategoryName, Description

   FROM Categories ;

END ;