By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
dbms_output:
create table peter_data as select kind,time_period,amount from all_data where kind = 'peter'
create table maria_data as select kind,time_period,amount from all_data where kind = 'maria'
create table eric_data as select kind,time_period,amount from all_data where kind = 'eric'
KIND | TIME_PERIOD | AMOUNT |
---|---|---|
peter | 20-OCT-20 | 1000 |
peter | 21-OCT-20 | 2000 |
KIND | TIME_PERIOD | AMOUNT |
---|---|---|
maria | 20-OCT-20 | 1000 |
KIND | TIME_PERIOD | AMOUNT |
---|---|---|
eric | 20-OCT-20 | 1000 |