query problum

[umesh049]

hi

 
DELETE FROM orders 
 WHERE order_id = :id;
 
 

can any body tell me what :id means in this query

and why and where we use : symbol

[amitpatel66]

hi

 
DELETE FROM orders 
 WHERE order_id = :id;
 
 

can any body tell me what :id means in this query

and why and where we use : symbol

Any variable prefixed with ":" are called BIND variables.You can create BIND variable this way and can be used in any source code program in that particular session.

 
SQL> VAR my_data VARCHAR2(20); -- Bind variable my_data created
SQL> EXEC :my_data:= 'Bind Variable' -- assigning a value to the bind variable
 
PL/SQL procedure successfully completed.
 
SQL> SELECT :my_data FROM dual; -- printing a Bind variable value
 
:MY_DATA
----------------------------------------------------------------------------------------------------
Bind Variable
 
SQL>