1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| INSERT INTO COMD_PM ( NUM_COMPM, NUM_CLI, TYPE_COMPM, DATE_COMPM ) VALUES (
'1007-0001', '6', 'maint', TO_Date( '10/08/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'));
INSERT INTO PREST_VEH ( NUM_COMPM, N_CHASS, NUM_PREST, TEMP_P,
PRIX_MAIND ) VALUES (
'1007-0001', 68465411, 1, '46m', NULL);
COMMIT;
INSERT INTO HUILE_PREST ( NUM_COMPM, N_CHASS, NUM_PREST, NUM_HL,
QT_HP ) VALUES (
'1007-0001', 68465411, 1, '15W40', 2.5);
COMMIT;
INSERT INTO PRIX_HUILE ( HUILE, DATE_P, PRIX_HL ) VALUES (
'15W40', TO_Date( '11/04/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 20);
INSERT INTO PRIX_HUILE ( HUILE, DATE_P, PRIX_HL ) VALUES (
'20W50', TO_Date( '11/03/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 100);
INSERT INTO PRIX_HUILE ( HUILE, DATE_P, PRIX_HL ) VALUES (
'20W50', TO_Date( '10/27/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 70);
INSERT INTO PRIX_HUILE ( HUILE, DATE_P, PRIX_HL ) VALUES (
'15W40', TO_Date( '10/10/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 50);
COMMIT; |
Partager