1-- Oracle
2
3-- EXAMPLE
4CREATE OR REPLACE PROCEDURE select_employees()
5BEGIN
6 select *
7 from employees
8 limit 1000; -- Remember, the delimiters within the stored procedure remain ;
9END;
10
11/* SYNTAX
12CREATE OR REPLACE PROCEDURE <Your-procedure-name>(<argument1><argument2>...<argumentN>)
13BEGIN
14 <Code-that-stored-procedure-executes>; -- Remember, the delimiters within the stored procedure remain ;
15END;
16*/