1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
create table table_t (id number, name varchar2(30), dat date, small_vc varchar2(5));
insert into table_t values (111,'DUPONT HENRI', to_date('20/09/2011','DD/MM/YYYY'),'x1');
insert into table_t values (111,'DUPONT HENRI', to_date('18/09/2011','DD/MM/YYYY'),'x1');
insert into table_t values (111,'DUPONT HENRI', to_date('17/09/2011','DD/MM/YYYY'),'x1');
insert into table_t values (222,'DUCOBU STEF', to_date('18/09/2011','DD/MM/YYYY'),'x1');
insert into table_t values (333,'PIERRE PIERRE', to_date('19/09/2011','DD/MM/YYYY'),'x1');
insert into table_t values (444,'PILON JEAN', to_date('20/09/2011','DD/MM/YYYY'),'x1');
insert into table_t values (555,'ALBERT BRUNO', to_date('15/09/2011','DD/MM/YYYY'),'x1');
commit; |