SQL> select empno, ename
2 from emp
3 where ename LIKE '%ll%';
SQL> save like01
Created file like01.sql
SQL> edit like01

select empno, ename
from emp
where ename LIKE '%LL%'

/

SQL> start like01

EMPNO ENAME
---------- ----------
7499 ALLEN
7934 MILLER

SQL>

SQL> edit like02

select empno, ename
from emp
where upper(ename) LIKE '%LL%'
/


SQL> start like02

EMPNO ENAME
---------- ----------
7499 ALLEN
7934 MILLER