CODE EXAMPLE FOR SQL

oracle string substitution

In SQL: 		:my_var
In PL/SQL: 		V('my_var') or NV('my_var')
In text: 		&my_var