[SQL] Oracle insert & (AND) character

To insert the & character in a string field in Oracle, you may need to split the string in two parts then concatenate them together putting the special character in the middle using the CHR function:

'string_part1'||chr(38)||'string_part2'