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 alsohttp://stackoverflow.com/questions/1137354/oracle-pl-sql-escape-character-for-a
 
No comments:
Post a Comment