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 views1 answer
Mysql change innodb to myisam
SQL
1 vote328 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote343 views1 answer
Oracle service name view
SQL
0 vote318 views1 answer
Enable Rabbitmq management plugin
SQL
1 vote342 views1 answer
Postgresql create table with timestamp
SQL
-2 votes333 views1 answer
Mysql see users and passwords
SQL
0 vote324 views1 answer
Sql change date format
SQL
0 vote373 views1 answer
How to use sqlcommand
SQL
1 vote314 views1 answer
Import in mysql without a software
SQL
11 votes311 views2 answers
Having keyword sql
SQL