Execution Plan

----------------------------------------------------------

----------------------------------------------------------------------------

| Id  | Operation                   | Name    | Rows  | Bytes | Cost (%CPU)|

----------------------------------------------------------------------------

|   0 | SELECT STATEMENT            |         |     1 |    57 |     5   (0)|

|*  1 |  TABLE ACCESS BY INDEX ROWID| EMP     |     1 |    37 |     2   (0)|

|   2 |   NESTED LOOPS              |         |     1 |    57 |     5   (0)|

|*  3 |    TABLE ACCESS FULL        | DEPT    |     1 |    20 |     3   (0)|

|*  4 |    INDEX RANGE SCAN         | EMP_X01 |     1 |       |     1   (0)|

----------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

1 - filter(TO_CHAR(INTERNAL_FUNCTION("E"."HIREDATE"),'yyyymmdd')

LIKE '198102%')

3 - filter("D"."LOC"='CHICAGO')

4 - access("E"."DEPTNO"="D"."DEPTNO" AND "E"."JOB" LIKE 'SALE%' AND

"E"."SAL">=1000 AND "E"."COMM">=300 AND "E"."SAL" IS NOT NULL)

filter("E"."ENAME" LIKE '%A%' AND "E"."JOB" LIKE 'SALE%' AND

"E"."SAL">=1000 AND TRIM("E"."ENAME")='ALLEN' AND "E"."JOB">='A' A

ND

"E"."JOB"<='Z' AND "E"."COMM">=300)