Hello, Effectively, your syntax perfectly function ... Thanks again ! Jean Berthold
SIM/HAOUHACH a écrit : > I think that it is possible to use the next syntax: > insert into grandeur_mesure2 > (ID_GRANDEUR,DATE_AQUISITION,VALEUR,VALIDITE,ID_TYPE_ACQUISITION,UTILISATION > ) > select > ( ID_GRANDEUR, to_char(JOUR,'DD')||' > '||to_char(HEURE,'HH24')||':'||to_char(MINUTE, 'MI'), VALEUR, VALIDITE, > ACQUISITION, UTILISATION ) > from grandeur_mesure > > L.Haouhach > Ingénieur système > Sonatrach > Algérie > > > -----Message d'origine----- > > De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > Date: lundi 12 novembre 2001 15:05 > > À: Multiple recipients of list ORACLE-L > > Objet: Insert into ... as select ... > > > > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SIM/HAOUHACH > 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). -- ________________________________ 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).
