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
| create table table_test (
nom varchar(30),
status varchar(20),
valeur_calcul number
);
insert into table_test values ('PLUTO' ,'ASSIS' ,2000);
insert into table_test values ('PLUTO' ,'DEBOUT' ,3560);
insert into table_test values ('CASPER' ,'ASSIS' ,56000);
insert into table_test values ('CASPER' ,'DEBOUT' ,45600);
insert into table_test values ('IDEFIX' ,'ASSIS' ,45445);
insert into table_test values ('IDEFIX' ,'DEBOUT' ,3400);
insert into table_test values ('RINTINTIN' ,'ASSIS' ,4560);
commit;
--Résultat souhaité
Nom Valeur_Assis Valeur_debout
PLUTO 2000 3560
CASPER 56000 45600
IDEFIX 45445 3400
RINTINTIN 4560 0 |
Partager