SQL> prompt 18c
18c
SQL> select * from(
2select
3
c_name,
4
c_custkey,
5
o_orderkey,
6
o_orderdate,
7
o_totalprice,
8
sum_l_quantity
9from
10
customer,
11
orders,
12
( select
13
l_orderkey,sum(l_quantity)sum_l_quantity
14
from
15
lineitem
16
group by
17
l_orderkey having
18
sum(l_quantity) > 312
19
)lineitem
20where
21
c_custkey = o_custkey
22
and o_orderkey = l_orderkey
23order by
24
o_totalprice desc,
25
o_orderdate
26)where rownum312)
Statistics
----------------------------------------------------------
169recursive calls
0db block gets
914940consistent gets
905472physical reads
0redo size
7033bytes sent via SQL*Net to client
586bytes received via SQL*Net from client
8SQL*Net roundtrips to/from client
1sorts (memory)
0sorts (disk)
100rows processed
SQL> prompt 18
18
SQL> select * from (select
2
c_name,
3
c_custkey,
4
o_orderkey,
5
o_orderdate,
6
o_totalprice,
7
sum(l_quantity)
8from
9
customer,
10
orders,
11
lineitem
12where
13
o_orderkey in (
14
select
15
l_orderkey
16
from
17
lineitem
18
group by
19
l_orderkey having
20
sum(l_quantity) > 312
21
)
22
and c_custkey = o_custkey
23
and o_orderkey = l_orderkey
24group by
25
c_name,
26
c_custkey,
27
o_orderkey,
28
o_orderdate,
29
o_totalprice
30order by
31
o_totalprice desc,
32
o_orderdate
33)where rownum312)
Statistics
----------------------------------------------------------
146recursive calls
0db block gets
1568034consistent gets
1551519physical reads
0redo size
7034bytes sent via SQL*Net to client
586bytes received via SQL*Net from client
8SQL*Net roundtrips to/from client
1sorts (memory)
0sorts (disk)
100rows processed
|