-
Contributing Member
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
-
Junior Member
Re: Host variable
&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...
-
Expert Member
Re: Host variable
For details of host,bind varible follow this links 1 & 2
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules