how to escape '&' character in oracle code example Example: pl sql escape ' INSERT INTO TABLE_A VALUES ( 'Alex''s Tea Factory' );