select 
       apxws_row_pk,
       "EMPNO",
       "ENAME",
       "JOB",
       "MGR",
       "HIREDATE",
       "SAL",
       "COMM",
       "DEPTNO",
       count(*) over () as apxws_row_cnt
 from (
select  * from (select b.ROWID apxws_row_pk, b.* from (select *  from (
select 
"EMPNO",
"ENAME",
"JOB",
"MGR",
"HIREDATE",
"SAL",
"COMM",
"DEPTNO"
 from   "EMP"
) ) b) r
) r where rownum <= to_number(:APXWS_MAX_ROW_CNT) 
 order by apxws_row_pk

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        7      0.00       0.00          0          6          0           7
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        9      0.00       0.00          0          6          0           7

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 92  (TEST)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   MODE: ALL_ROWS
      0   WINDOW (SORT)
      0    COUNT (STOPKEY)
      0     TABLE ACCESS   MODE: ANALYZED (FULL) OF 'EMP' (TABLE)

  select apxws_row_pk
, "EMPNO"
, "ENAME"
, "JOB"
, "MGR"
, "HIREDATE"
, "SAL"
, "COMM"
, "DEPTNO"
   from
  (select *
     from
    (select b.rowid apxws_row_pk
    , b.*
       from
      (select *
         from
        (select "EMPNO"
        , "ENAME"
        , "JOB"
        , "MGR"
        , "HIREDATE"
        , "SAL"
        , "COMM"
        , "DEPTNO"
           from "EMP"
        )
      ) b
    ) r
    where
    (
      "JOB" = :apxws_expr_1
    )
  ) r
  where rownum <= to_number(:apxws_max_row_cnt)
order by apxws_row_pk 

1. APXWS_EXPR_1=MANAGER
2. APXWS_MAX_ROW_CNT=1000000