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 vote235 views1 answer
Sqlalchemy existing database
SQL
0 vote308 views1 answer
Sql output select
SQL
0 vote305 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
9 votes304 views2 answers
Sql limit to 5 results
SQL
5 votes320 views1 answer
Purge undo tablespace usage
SQL
6 votes271 views1 answer
Phpmyadmin reset root password
SQL
4 votes279 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote283 views1 answer
Sql server select ignore dupplicates
SQL
2 votes297 views1 answer
Guid to string sql
SQL
1 vote308 views1 answer
Oracle undo usage per session
SQL