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