Re: Insert into ... as select ...

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

nlzanen1_at_EY.NL 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
>
> jean.berthold_at_eos-gd.ch (Jean Berthold)@fatcity.com on 12-11-2001 16:05:22
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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 : jean.berthold_at_eos-gd.ch
> ________________________________
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jean Berthold
> INET: jean.berthold_at_eos-gd.ch
>
> 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: ListGuru_at_fatcity.com (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: nlzanen1_at_EY.NL
>
> 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: ListGuru_at_fatcity.com (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 : jean.berthold_at_eos-gd.ch
________________________________


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jean Berthold
  INET: jean.berthold_at_eos-gd.ch

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: ListGuru_at_fatcity.com (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).