Top "Bind-variables" questions

A bind variable is an unspecified value (in other words, a placeholder) in a prepared database statement/command.

What does the colon sign ":" do in a SQL query?

What does : stand for in a query? INSERT INTO MyTable (ID) VALUES (:myId) How does it fetch the desired value? …

sql oracle plsql bind-variables
Python cx_Oracle bind variables

I am a Python newbie, I am having troubles in the use of bind variables. If I execute the code …

python cx-oracle bind-variables
use of bind variable

Can we use a bind variable in oracle inside a procedure or function ? I'm trying to update a bind variable …

oracle bind-variables
sqlplus - using a bind variable in "IN" clause

I am setting a bind variable in a PL/SQL block, and I'm trying to use it in another query's …

oracle oracle10g sqlplus ora-01722 bind-variables
Declaration of multiple values in Oracle BIND Variables

I am trying to pass multiple values about 3000 values, to a BIND variable in Oracle SQL PLUS command prompt like.. …

sql oracle bind-variables
PLSQL not all variables bound

i keep getting the following errror, 'ORA-01008: not all variables bound', im guessign its all based on my pPostcode param …

oracle plsql bind-variables
How to get tracing info for binding variables passed through OracleParameter in ODP.NET?

After Googling a lot and not finding what I'm looking for I decided to ask this question. I'm using binding …

sql oracle odp.net trace bind-variables
ExecuteReader with Oracle array binding

I'm trying to improve performance of my Oracle SQL queries by using array binding to an OracleParameter. This is basically …

c# arrays oracle bind-variables executereader
PL/SQL code using :1, :2, :3 and so on

What is the meaning of this code and what do you call this method? How will I know what is …

sql oracle stored-procedures plsql bind-variables
Oracle OCI, bind variables, and queries like ID IN (1, 2, 3)

Succinct Version: I'm looking for a C++ OCI adaptation of the following Java technique, where code is able to bind …

c++ sql oracle oracle-call-interface bind-variables