Saturday, March 31, 2012

How to print special character in sqlplus?

SET ESCAPE ON
select 'TEST1\&TEST2' from dual;


SET ESCAPE ON
UPDATE TABLE1 SET FIELD1='TEST1\&TEST2';

No comments:

Post a Comment