escape character pl sql _ code example

Example 1: pl sql escape &

-- 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

Example 2: pl sql escape '

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