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

Source: stackoverflow.com

Similar codes

15 votes218 views2 answers
Sql order by multiple columns
SQL
2 votes232 views1 answer
Add 2 hours to current time in MySQL
SQL
13 votes237 views2 answers
Get tables in database sql
SQL
0 vote362 views1 answer
Sql change a colum to unique
SQL
0 vote222 views1 answer
Oracle sql date winter time
SQL
10 votes221 views4 answers
Mysql one week ago
SQL
31 votes235 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote217 views4 answers
How to drop all tables in sql
SQL
2 votes243 views1 answer
Mysql set value as null
SQL
4 votes225 views3 answers
Mysql modify foreign key
SQL