to escape underscore use / and escape / before underscore
WHERE mycolumn LIKE '%\_%' ESCAPE '\' For writing records with single quotes :- select q'?My mother's key is missing?' from dual O/p My mother's key is missing So as a simple rule q'?_______your_sentence__________?' this tells browser to type your sentence as it is.
WHERE mycolumn LIKE '%\_%' ESCAPE '\' For writing records with single quotes :- select q'?My mother's key is missing?' from dual O/p My mother's key is missing So as a simple rule q'?_______your_sentence__________?' this tells browser to type your sentence as it is.
No comments:
Post a Comment