Non-PL/SQL variables: bind and host
Objective Use non-PL/SQL bind, host variables to manipulate dat
A bind variable is a variable that you declare in a host environment and then use to pass runtime values.
These values can be character or numeric. You can pass these values either in or out of one or more PL/SQL programs, such as packages, procedures, or functions.
SQL*Plus is a good example of a host environment.