create table t as
select owner accountno , trunc(created) as tran_date,object_id as amount from all_objectsTable created.
select accountno,count(*), sum(amount) from t group by accountno| ACCOUNTNO | COUNT(*) | SUM(AMOUNT) | SQL_GAMSASMDVWWDRZSPJYDICCINX | 5 | 42217135 | MDSYS | 2032 | 1132977390 | AV | 4 | 5069286 | AD | 17 | 140841209 | DD | 19 | 3404755 | OLYM | 28 | 21787542 | PUBLIC | 12029 | 4106963316 | CTXSYS | 110 | 5585433 | HR | 27 | 570483 | APEX_050100 | 4 | 6235399 | SCOTT | 4 | 379398 | EXFSYS | 1 | 420725 | ORDSYS | 3129 | 1645880697 | SH | 93 | 1994945 | OE | 11 | 67878726 | ORDS_METADATA | 41 | 320050484 | ORDPLUGINS | 5 | 2060850 | XDB | 72 | 41285315 | WORLD | 1 | 26053 | ORDDATA | 274 | 112860880 | SYS | 2562 | 1317769217 | LIVESQL | 7 | 7156728 |
|---|
select accountno from t group by accountno having sum(amount) > 1000| ACCOUNTNO | SQL_GAMSASMDVWWDRZSPJYDICCINX | MDSYS | AV | AD | DD | OLYM | PUBLIC | CTXSYS | HR | APEX_050100 | SCOTT | EXFSYS | ORDSYS | SH | OE | ORDS_METADATA | ORDPLUGINS | XDB | WORLD | ORDDATA | SYS | LIVESQL |
|---|