Create or replace a procedure : Procedure « Function Procedure Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Function Procedure Packages
3. Procedure

SQL> create or replace PROCEDURE swapn (num_one IN OUT NUMBER, num_two IN OUT NUMBER) IS
  2      temp_num    NUMBER;
  3  BEGIN
  4      temp_num := num_one;
  5      num_one := num_two;
  6      num_two := temp_num ;
  7  END;
  8  /

Procedure created.

SQL>