SQL> select * from DEPT;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
 
SQL> select * from dept where 1=1 and (deptno like '%3%' or DNAME like 'SA%'); 

    DEPTNO DNAME          LOC
---------- -------------- -------------
        30 SALES          CHICAGO