How to search data from oracle database which contains single quote.

Question

Hi All,

i have one table my_table,which contains three columnn namely name,address1,address2. Now i want to search a data from these 3 column which contains single quote. Can anybody suggest. Thanks in advance.

Answer 1

You have to escape the single quotes in the expressions by doubling them, e.g.:

select * from my_table
where name like '%''%'
or address1 like '%''%'
or address2 like '%''%';

Answer 2

... where name || address1 || address2 like '%''%';