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