Geeks Talk

Prepare for your Next Interview




Host variable

This is a discussion on Host variable within the Oracle forums, part of the Databases category; 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...


Go Back   Geeks Talk > Databases > Oracle

Host variable Host variable

Register FAQ Members List Calendar Mark Forums Read

Reply

 

Thread Tools Display Modes
  #1 (permalink)  
Old 03-01-2008
Contributing Member
  
Join Date: Mar 2008
Posts: 81
Thanks: 14
Thanked 3 Times in 3 Posts
babi_geek is on a distinguished road
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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 03-03-2008
Junior Member
  
Join Date: Feb 2008
Location: Edinburgh
Posts: 21
Thanks: 3
Thanked 2 Times in 2 Posts
su123 is on a distinguished road
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...
Reply With Quote
  #3 (permalink)  
Old 03-03-2008
Expert Member
  
Join Date: Apr 2007
Location: Bangalore
Posts: 431
Thanks: 18
Thanked 53 Times in 53 Posts
susarlasireesha is on a distinguished road
Re: Host variable
For details of host,bind varible follow this links 1 & 2
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle

« Statement level triggers | doubt in sql »

Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Thread Thread Starter Forum Replies Last Post
Parameter variable and Mapping variable kiranmanju Data Warehousing 0 01-08-2008 03:17 AM
Invalid host/bind variable name k_sakthivel Oracle 1 11-20-2007 01:34 AM
Host vijenjoy2k2 LoadRunner 1 09-06-2007 11:29 AM
Normal Variable and the Comp-3 Variable in Cobol Geek_Guest MainFrame 0 07-04-2007 08:47 PM
Host username and password for Oracle 10g supremo Oracle 1 06-25-2007 01:59 AM


All times are GMT -4. The time now is 06:21 PM.

Contact Us - Geeks Discussions - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved