Hello everybody, I have a problem to find the correct syntax for the following operation:
The first table: SQL> describe grandeur_mesure; Name Null? Type ----------------------------------------- -------- ---------------------------- ID_GRANDEUR NOT NULL NUMBER(15) JOUR NOT NULL DATE HEURE NOT NULL NUMBER(15) MINUTE NOT NULL NUMBER(15) VALEUR FLOAT(126) VALIDITE NUMBER(1) ACQUISITION NUMBER(15) UTILISATION NUMBER(15) SQL> The second table: ------------------ SQLWKS> describe grandeur_mesure2 Nom de la colonne Null? Type ------------------------------ -------- ---- ID_GRANDEUR NOT NULL NUMBER(15) DATE_AQUISITION NOT NULL DATE VALEUR FLOAT VALIDITE NUMBER(1) ID_TYPE_ACQUISITION NUMBER(15) UTILISATION NUMBER(15) ID_COMPTEUR NUMBER(15) ID_TYPE_GRANDEUR NUMBER(15) ID_UNITE NUMBER(1 I try to insert all the rows from the first table into the second table and "concat" the following fields: describe grandeur_mesure.JOUR describe grandeur_mesure.HEURE describe grandeur_mesure.MINUTE Into: describe grandeur_mesure2.DATE_AQUISITION Please, do you know which is the correct command line ? Thank you for your help ! -- ________________________________ Jean Berthold EOS - energie ouest suisse Chemin de Mornex 10 , CP 570 CH-1001 Lausanne , Switzerland Tel. : +41 (0)21 341 24 58 Fax : +41 (0)21 341 20 49 E-Mail : [EMAIL PROTECTED] ________________________________ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jean Berthold INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).