Monday, 20 July 2015

How to display the ename from emp, which contains '%' and '_' in ename ?

'%'  and  '_' are special characters in oracle.   To compare these characters in the ename, we need to work with the ESCAPE clause.

EX:
==

select ename from emp where ename like '% /%'  escape '/';

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...