1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
| select INDEX_PLACEMENT_SECOND from gast2.accueil_second2;
MERGE INTO gast2.ACCUEIL_SECOND2 aa USING gast2.ACCUEIL_SECOND b ON (aa.INDEX_PLACEMENT_SECOND = b.INDEX_PLACEMENT_SECOND )
WHEN MATCHED THEN
UPDATE SET aa.INDEX_PLACEMENT_SECOND = b.INDEX_PLACEMENT_SECOND, aa.INDEX_DOSSIER_ASSMAT = b.INDEX_DOSSIER_ASSMAT
WHEN NOT MATCHED THEN
INSERT (aa.INDEX_PLACEMENT_SECOND, aa.INDEX_DOSSIER_ASSMAT) VALUES (b.INDEX_PLACEMENT_SECOND, b.INDEX_DOSSIER_ASSMAT);
INDEX_PLACEMENT_SECOND
----------------------
0 rows selected
Error starting at line 2 in command:
MERGE INTO gast2.ACCUEIL_SECOND2 aa USING gast2.ACCUEIL_SECOND b ON (aa.INDEX_PLACEMENT_SECOND = b.INDEX_PLACEMENT_SECOND )
WHEN MATCHED THEN
UPDATE SET aa.INDEX_PLACEMENT_SECOND = b.INDEX_PLACEMENT_SECOND, aa.INDEX_DOSSIER_ASSMAT = b.INDEX_DOSSIER_ASSMAT
WHEN NOT MATCHED THEN
INSERT (aa.INDEX_PLACEMENT_SECOND, aa.INDEX_DOSSIER_ASSMAT) VALUES (b.INDEX_PLACEMENT_SECOND, b.INDEX_DOSSIER_ASSMAT)
Error at Command Line:2 Column:69
Error report:
SQL Error: ORA-00904: "AA"."INDEX_PLACEMENT_SECOND" : identificateur non valide
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action: |
