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

17 votes262 views4 answers
Mysql remove ubuntu
SQL
0 vote193 views1 answer
What is metadata in sql
SQL
1 vote188 views1 answer
Trigger in postgresql to change incoming entry
SQL
7 votes203 views2 answers
Oracle sql drop index
SQL
4 votes186 views1 answer
Mysql insert from local csv
SQL
3 votes189 views4 answers
Mysql decimal
SQL
4 votes200 views6 answers
List all tables in postgres
SQL
4 votes186 views1 answer
What are the data types in sql
SQL
0 vote201 views1 answer
Get first 3 letter of department name in sql
SQL
1 vote195 views1 answer
List all triggers in SQL Server
SQL