PLSQL - Procedure

> Procedural Languages > PL/SQL - (Procedure Language|PL) SQL

1 - Parameter binding

  • By (Index|position): List the values in the order the arguments appear in the procedure declaration.
-- With the following procedure signature Sal_raise(Emp_id number, Sal_incr number);
Sal_raise(7369, 500);
-- 7369 is for emp_id
-- 500 is for the increase in salary
  • By Name: Specify the argument names and corresponding values, in any order.
Sal_raise(Sal_incr=>500, Emp_id=>7369);
  • A mix of the two
Sal_raise(7369, Sal_incr=>500);

2 - Documentation / Reference

Advertising
lang/plsql/procedure.txt · Last modified: 2017/09/06 22:18 by gerardnico