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

5 votes351 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote351 views1 answer
Modificar tipo de dato sql server
SQL
6 votes338 views1 answer
Rank function in oracle with example
SQL
0 vote357 views1 answer
Mysql config slave
SQL
0 vote354 views1 answer
Hibernate xml property MySQL url, username and password
SQL
24 votes396 views4 answers
Postgres delete database
SQL
4 votes363 views1 answer
Search column by name mysql
SQL
0 vote361 views1 answer
Php select data from mysql database without column name
SQL
0 vote330 views1 answer
Store query result in variable sql
SQL
0 vote299 views1 answer
Copy table dbeaver
SQL