Is it feasible to escape ' (single quote) with ESCAPE clause, if yes, then how to do it?
Why do you think it should be escaped? Special characters that should be escaped when using LIKE operator are % and _.

SQL&gt; select * from test_t where x like '%''%';

X
--------------------------------------------------------------------------------
it's a string

SQL&gt; select * from test_t where x like q'[%'%]';

X
--------------------------------------------------------------------------------
it's a string