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

0 vote343 views3 answers
Join
SQL
0 vote271 views1 answer
Sql table to store status
SQL
0 vote332 views1 answer
C# mysql update statement set value to null
SQL
42 votes402 views6 answers
Sql query duplicate rows
SQL
0 vote343 views1 answer
How to find total working hour in sql
SQL
0 vote337 views1 answer
Enable sql server full text indexing
SQL
0 vote330 views1 answer
Sql server change schema of a table
SQL
0 vote344 views1 answer
Will graphql replace sql
SQL
1 vote303 views1 answer
MySQL AND Operator
SQL
0 vote371 views1 answer
Oracle chain step succeeded
SQL