| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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:
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 Liststo: 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). Received on Mon Nov 12 2001 - 09:17:33 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |