SQL> SELECT SUM(t1 + t2 + t3 + t4 + t5 + t6 + t7) AS tn, acc_num
2 FROM acc_pos_cash_pl_vw /*视图acc_pos_cash_pl_vw*/
3 WHERE business_date = '20110712'
4 AND (('20110712' = '20110713' AND is_arch = 'N') OR
5 ('20110712' <> '20110713' AND is_arch = 'Y'))
6 GROUP BY acc_num;
TN ACC_NUM
---------- -------------
-42012 0000008001011
-42152.36 0000007001011
55924.31 0203531001011
11328390.4 9999991001011
10809.61 0310788002021
0 0112825002021
54202.65 0011453001011
7 rows selected.
Plan hash value: 1199745409
-------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers |
| 1 | HASH GROUP BY | | 1 | 43729 | 7 |00:00:00.01 | 9 |
| 2 | VIEW | ACC_POS_CASH_PL_VW | 1 | 43729 | 7 |00:00:00.01 | 9 |
| 3 | UNION-ALL | | 1 | | 7 |00:00:00.01 | 9 |
|* 4 | FILTER | | 1 | | 0 |00:00:00.01 | 0 |