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

1 vote163 views1 answer
Oracle user last connected
SQL
0 vote163 views4 answers
Mysql desactivar trigger
SQL
2 votes161 views1 answer
Get first n letter of department name in sql
SQL
0 vote180 views8 answers
Convert sql query to linq online
SQL
1 vote189 views1 answer
Oracle drop temporary table
SQL
0 vote180 views1 answer
Mysql delete from where like
SQL
0 vote182 views1 answer
Postgresql inline table
SQL
0 vote190 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
1 vote187 views1 answer
Postgresql round double precision
SQL
6 votes165 views1 answer
Oracle desc table primary key
SQL