Difference between 'bind' n 'host' variables on SQL,PL/SQL.? - hosting pl
Bind variables are variables that host, ie in the area defined tools (forms or sqlplus repport ...) and is used in SQL queries or PL / SQL code.
Note that an element of a form or setting repport in a host variable in comparison to a local variable in PL / SQL.
For example:
Suppose that an element of a form to block I called TEXT
To reference the value of the host valriable in an assignment will be written as
: Label: = "text";
You should, however, the difference between a variable and a lexicon bind variables.
Reference tend to bind to the variable value of the work, meanwhile, mines LEXICON Replace the variable reference syntax in the lexicon of their value.
Lexical variables are possible in repport quoting reference tool.
DIS is the best answer!
Sunday, January 31, 2010
Hosting Pl Difference Between 'bind' N 'host' Variables On SQL,PL/SQL.?
1 comment:
Home Variables
In a block of PL / SQL, host variables are global for the entire block and can be used anywhere a variable in PL / SQL is not allowed. Like host variables in a SQL statement must be host variables in a block of PL / SQL will be preceded by a colon. The colon contains host variables, several variables in PL / SQL and database objects.
Host Variables and PL / SQL
The host variables are the key to communication between a host language and PL / SQL. Host variables with PL / SQL, PL ie shared / SQL can set the variable and reference host.
For example, a user information and host can use variables to information about a PL / SQL Pass. Then, PL / SQL access to the database and host variables used to pass the results to your host program.
In a block of PL / SQL, host variables are as globally for the entire block and can be used anywhere a variable in PL / SQL is acceptable treatment. Like host variables in a SQL statement must be host variables in a block of PL / SQL will be preceded by a colon. The colon contains host variables apart from PL /The variables and database objects in SQL.
Bind variable:
Sometimes what you want to locally the value of a variable PL / SQL to print. A `` quick and sucio''a how the tuple is stored a unique relationship and after the pressure PL / SQL connection with a SELECT statement. A Couth is a bind variable to define is the only kind that can be printed with a print command. Bind variables are the type, with a colon in PL / SQL, how must be preceded by:
Post a Comment