Thread: Host variable

Hi friends

I am babi. New to this forum.
What is the difference between host variable and bind variable?
What is difference between & and :?

Regards
Babi

&variable_name; (substitution variable)
:variable_name; (bind variable)

For example in a query such as:

OPEN CURSOR (&my_var)
OPEN CURSOR (:my_var)

Sorry I don’t know the exact difference between Bind and Host variable,
Usually we will use Bind variables in SQL and PL/SQL at application level, I think we can use this Host variables at Database level.
I am not so sure about this Please Ignore it...

For details of host,bind varible follow this links 1 & 2