Wednesday, February 19, 2014

Oracle: How to escape an &


Insert into BRMF_VALUE_CATALOG (ID,TITLE,TYPE,CAN_HAVE_CHILDREN,PARENT_ID) values (322,'&MORE','Generic_Suffix_Basket',0,3);
DOES not work
 

escape the & with || chr(38) ||

Insert into BRMF_VALUE_CATALOG (ID,TITLE,TYPE,CAN_HAVE_CHILDREN,PARENT_ID) values (322,chr(38) || 'MORE','Generic_Suffix_Basket',0,3);




See also
http://stackoverflow.com/questions/1137354/oracle-pl-sql-escape-character-for-a
 

No comments:

Post a Comment