pl sql escape '
snippet in sql

pl sql escape &

user9572

-- syntax (This is specifically for PLSQL)
||CHR(38)||

-- example (You want: 'This symbol, &, works!')
'This symbol, '||CHR(38)||', works!'

-- Note: You could also use the "SET DEFINE ~;" code. Please see the 
-- reference/source (URL) for more details

pl sql escape '

user9653

INSERT INTO TABLE_A VALUES ( 'Alex''s Tea Factory' );