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 vote160 views1 answer
Postgres clear table
SQL
6 votes185 views3 answers
Rename column ORACLE
SQL
0 vote179 views1 answer
Prisma transaction
SQL
5 votes137 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote105 views1 answer
Online sql compiler
SQL
8 votes147 views1 answer
How to check mysql version in xampp
SQL
1 vote141 views1 answer
Truncate left characters mysql
SQL
0 vote143 views1 answer
Sql row number in result set
SQL
0 vote139 views1 answer
Sql developer search all packages for text
SQL
0 vote154 views1 answer
Datagrip execute procedure
SQL