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:
peter
create table peter_data as select kind,time_period,amount from all_data where kind = 'peter'
maria
create table maria_data as select kind,time_period,amount from all_data where kind = 'maria'
eric
create table eric_data as select kind,time_period,amount from all_data where kind = 'eric'
KIND | TIME_PERIOD | AMOUNT |
---|---|---|
peter | 21-SEP-22 | 1000 |
peter | 22-SEP-22 | 2000 |
KIND | TIME_PERIOD | AMOUNT |
---|---|---|
maria | 21-SEP-22 | 1000 |
KIND | TIME_PERIOD | AMOUNT |
---|---|---|
eric | 21-SEP-22 | 1000 |