How to search for single quote in Oracle11g -

How to search for single quote in Oracle11g -

how can search name o'neil table when utilize query

select * table_name name 'o'neil';

then shows error.

escape sec single quote:

select * table_name name 'o''neil';

since oracle 10g there quote-operator:

select * table_name name q'('o'neil)';

syntax: q'c text-to-be-quoted c'. c single character (called quote delimiter). «quote operator» apostrophes don't have doubled.

oracle11g