sathish-io · May 5, 2014 07:38
diff --git a/Oracle escaping '&' character b/Oracle escaping '&' character
 some times, you are in need of doing DML operation that involves strings with & sign in it. 
 Oracle sql clients treats this as a substitution variables and prompts you to enter value.

 For example when you run below select statement; it prompts you to enter value for "T".
 select 'A&T' from dual;

 To disable this you can disable substitution variables for your session using "SET DEFINE OFF"
 Note: & is the default value for DEFINE.

 SET DEFINE OFF
 select 'A&T' from dual;
	some times, you are in need of doing DML operation that involves strings with & sign in it.
	Oracle sql clients treats this as a substitution variables and prompts you to enter value.

	For example when you run below select statement; it prompts you to enter value for "T".
	select 'A&T' from dual;

	To disable this you can disable substitution variables for your session using "SET DEFINE OFF"
	Note: & is the default value for DEFINE.

	SET DEFINE OFF
	select 'A&T' from dual;