Bind Referencing / Parameter
Bind references are used to replace a single value in SQL or PL/SQL, such as a character string, number, or date. Use bind reference when you want the parameter to substitute only one value at runtime. Specifically, bind references may be used to replace expressions in SELECT, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH clauses of queries.
Bind parameters are used to substitute single value at runtime for evaluation and are identified by a preceding ‘:’ .
An example of a bind parameter in a select statement is provided below, where :P_Name is the bind parameter reference.
Select Name,Department,Position
From my_Table
Where Dept = :P_Dept
These are used as tokens while registering concurrent program
July 15th, 2010 at 8:42 pm
Buy:Valtrex.Zovirax.Zyban.Petcam (Metacam) Oral Suspension.Synthroid.Nexium.Prednisolone.Actos.Retin-A.Human Growth Hormone.Mega Hoodia.Lumigan.Prevacid.Accutane.Arimidex.100% Pure Okinawan Coral Calcium….
July 21st, 2010 at 10:23 pm
Buy:Advair.Zetia.Lipothin.Nymphomax.Prozac.Cozaar.Wellbutrin SR.Benicar.Acomplia.Amoxicillin.Seroquel.Ventolin.Lipitor.Female Pink Viagra.Lasix.Aricept.Buspar.Zocor.SleepWell.Female Cialis….