1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| create table MaTable
( cod varchar2(5) not null
, num number(3) not null
, val number(3) not null
, dt date not null
, constraint pk_MaTable
primary key (cod, num, dt)
using index
)
compress
pctfree 0
;
insert all
into MaTable (cod, num, val, dt) values('PEDFR', 365, 70, to_date('19/07/19 11:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('SO2 ', 80, 97, to_date('19/07/19 11:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('PEDFR', 365, 52, to_date('19/07/19 12:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('SO2 ', 80, 95, to_date('19/07/19 12:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('SO2 ', 80, 97, to_date('19/07/19 13:53:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('PEDFR', 365, 31, to_date('19/07/19 17:09:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('SO2 ', 80, 94, to_date('19/07/19 17:09:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('PEDFR', 365, 32, to_date('19/07/19 20:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('SO2 ', 80, 93, to_date('19/07/19 20:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('SO2 ', 80, 94, to_date('20/07/19 01:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('PEDFR', 365, 16, to_date('20/07/19 01:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('PEDFR', 365, 38, to_date('20/07/19 05:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('SO2 ', 80, 97, to_date('20/07/19 05:00:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('SO2 ', 80, 95, to_date('20/07/19 07:30:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('PEDFR', 365, 49, to_date('20/07/19 07:30:00', 'dd/mm/rr hh24:mi:ss'))
into MaTable (cod, num, val, dt) values('SO2 ', 80, 100, to_date('20/07/19 11:51:00', 'dd/mm/rr hh24:mi:ss'))
select * from dual;
commit; |
Partager