What Is A Bind Variable And How Is It Used?

1.	What Is A Bind Variable And How Is It Used?
Answer» A bind variable is a variable within a SQL statement that has to be replaced by a VALID value on the successful execution of the statement. This value can be referenced into the PL/SQL block. Bind variable is ALWAYS PRECEDED by a COLON (:), as shown in the FOLLOWING code: Declare y_emp_age number; Begin Select emp-age into :v_empLage from t_employee where emp_code.121; End; In the preceding code, v_emp_age is a bind variable. A bind variable is a variable within a SQL statement that has to be replaced by a valid value on the successful execution of the statement. This value can be referenced into the PL/SQL block. Bind variable is always preceded by a colon (:), as shown in the following code:

Answer»

A bind variable is a variable within a SQL statement that has to be replaced by a VALID value on the successful execution of the statement. This value can be referenced into the PL/SQL block. Bind variable is ALWAYS PRECEDED by a COLON (:), as shown in the FOLLOWING code:

Declare y_emp_age number; Begin Select emp-age into :v_empLage from t_employee where emp_code.121; End; In the preceding code, v_emp_age is a bind variable.

A bind variable is a variable within a SQL statement that has to be replaced by a valid value on the successful execution of the statement. This value can be referenced into the PL/SQL block. Bind variable is always preceded by a colon (:), as shown in the following code:

Discussion

No Comment Found

Related InterviewSolutions

Do Stored Procedures And Functions Within The Same Schema Share The Same Namespace?
Give A Sql Statement So That The Procedure Proc_1 In The Package Pack_sample Is Granted Access To All The Users In The Database ?
Give A Sql Statement To Grant Access On The Procedure Proc_sample In The Schema, Schema_a.
Is It Possible To Create A Package Body And Store It In A Database?
Give The Sql Statement To Drop The Package Specification For Pack_a Without Dropping The Package Body ?
Suppose A Procedure Proc_1 Refers To A Procedure Proc_2 Within The Pack_1 Package. If The Definition Of The Proc_2 Procedure Is Changed And It Is Recompiled Again, Then Does The Proc_1 Procedure Is Invalidated ?
Explain The Grant And Revoke Dcl Statements ?
Which Data Dictionary View Will Give The Owner Name Along With The Privileges On A Schema Object?
Which Column In The User_sys_privs View Determines Whether The System Privilege Is With Admin Option ?
Write A Pl/sql Statement To Show The Privileges On A Procedure Proc_1 Within The Schema A ?