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 vote192 views1 answer
Group by sql not ordering issues
SQL
0 vote188 views1 answer
Truncate table sql server foreign key
SQL
0 vote212 views1 answer
Use mysql in java program
SQL
0 vote180 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote204 views1 answer
Oracle tablespace autoextend
SQL
0 vote148 views2 answers
How to combine two sql queries in one result
SQL
2 votes201 views3 answers
How to check current user in mySQL
SQL
5 votes201 views1 answer
Invalid column name sql
SQL
-1 vote201 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote204 views1 answer
Oracle truncate partition
SQL