Insert into COMMANDE (COMMANDEID,NUMEROCOMMANDE,NUMEROREVISION,DATECOMMANDE,DATELIVRAISONPREVUE,DATEEXPEDITION,ETAT,ESTCOMMANDEENLIGNE,CLIENTID,EXPEDITEURID,ADRESSEFACTURATIONID,ADRESSEEXPEDITIONID,VENDEURID,CODEDEVISE,SOUSTOTAL,TAXE,FRAISTRANSPORT,NOTE,TOTALORDRE,GEOID,DATEDERNIEREMODIFICATION) values (65,'131-00065','8',to_date('15/05/06','DD/MM/RR'),to_date('20/05/06','DD/MM/RR'),null,'V',1,4896,1,110784,277322,133,'EUR',134,42,6,8,26,null,169,56,240,to_timestamp('19/10/07 13:38:13,007000000','DD/MM/RR HH24:MI:SS,FF'));
La table est déjà créee bien sûr.
Partager