The instr function can be used to find if the given string is present in a particular column or not.
Example for this is given below.
SQL> SELECT ename
FROM emp
WHERE instr(ename , 'LL')>0;
ENAME
----------
ALLEN
MILLER
Using INSTR will be much faster than using like in these kind of scenarios.
No comments:
Post a Comment