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,Value
From XX_Table
Where Name= :P_Name