Sams Teach Yourself SQL in 10 Minutes, Second Edition

CREATE PROCEDURE

CREATE PROCEDURE is used to create a stored procedure. See Lesson 19, “Working with Stored Procedures,” for more information. Oracle uses a different syntax as described in that lesson.

CREATE PROCEDURE procedurename [parameters] [options]
AS
SQL statement;