Pl sql escape '

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

Pl sql escape '

INSERT INTO TABLE_A VALUES ( 'Alex''s Tea Factory' );

Source: stackoverflow.com

Similar codes

0 vote216 views1 answer
Check if mysql db is used
SQL
1 vote238 views1 answer
Pentaho + pasar de excel a sql
SQL
2 votes192 views1 answer
How to check if a row is null in sql
SQL
0 vote262 views1 answer
Generate random & unique mysql string
SQL
2 votes233 views1 answer
Revokeprivileges mysql
SQL
50 votes272 views4 answers
Sql alter type of column
SQL
0 vote185 views1 answer
Oracle query archive mode
SQL
0 vote205 views1 answer
Add sqlcmd to path linux
SQL
0 vote219 views1 answer
Delete first row in sql
SQL
0 vote181 views1 answer
How to connect pgadmin with excel
SQL