Passing several bind variables : Binded variable « PL SQL Statements « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Statements
  3. Binded variable

Bind variables can be considered as parameters.

You can have as many bind variables.

You can use the following syntax to pass value to bind variables:

execute immediate
  '...:var1,:var2,:var3...' (code with bind variables)
using
  v_A,v_B,'Y'...(comma-separated list of values/variables)








22.14.Binded variable
22.14.1.Understanding bind variable types
22.14.2.Passing several bind variables
22.14.3.Using Multiple Bind Variables
22.14.4.Using a NULL bind variable
22.14.5.Reusing Bind Variables in Dynamic SQL
22.14.6.Use quotation with a bind variable