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

37 votes543 views3 answers
Sql check duplicate value in column
SQL
0 vote346 views1 answer
Modificar tipo de dato sql server
SQL
8 votes336 views1 answer
Sql remove characters from string right
SQL
0 vote360 views1 answer
Table or view does not exist
SQL
0 vote426 views1 answer
Mariadb change column type
SQL
1 vote367 views2 answers
Get table column names sql laravel
SQL
2 votes364 views2 answers
How to run postgresql in linux
SQL
0 vote350 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
2 votes326 views1 answer
Plsql left() function
SQL
25 votes356 views4 answers
Metadata
SQL