Hello Jack, because I have need to recover information of an existing table that had a field dates decomposed in field dates, field hour field times. I have need to recover all existing information in an unique field dates, in the new table...
I hope that you will understand my explanations, my knowledge of English not being very good... Thank you ! Jean Berthold [EMAIL PROTECTED] a �crit : > Hi > > Both 'DATE_AQUISITION' and 'JOUR' are date fields. > > Why would you want to add hour and minute to a field that already contains > this information? > > Jack > > [EMAIL PROTECTED] (Jean Berthold)@fatcity.com on 12-11-2001 16:05:22 > > Please respond to [EMAIL PROTECTED] > > Sent by: [EMAIL PROTECTED] > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) > > 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). > > ===================================================================== > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is > uitsluitend bestemd voor de geadresseerde. Openbaarmaking, > vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan > derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & > Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en > volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch > voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een > verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten > worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. > > Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u > vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender > en het origineel en eventuele kopie�n te verwijderen en te vernietigen. > > Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene > voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De > algemene voorwaarden worden u op verzoek kosteloos toegezonden. > ===================================================================== > The information contained in this communication is confidential and is > intended solely for the use of the individual or entity to whom it is > addressed. You should not copy, disclose or distribute this communication > without the authority of Ernst & Young. Ernst & Young is neither liable for > the proper and complete transmission of the information contained in this > communication nor for any delay in its receipt. Ernst & Young does not > guarantee that the integrity of this communication has been maintained nor > that the communication is free of viruses, interceptions or interference. > > If you are not the intended recipient of this communication please return > the communication to the sender and delete and destroy all copies. > > In carrying out its engagements, Ernst & Young applies general terms and > conditions, which contain a clause that limits its liability. A copy of > these terms and conditions is available on request free of charge. > ===================================================================== > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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).
