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 27 28 29 30 31 32 33 34 35 36
|
Connected to Oracle Database 10g Express Edition Release 10.2.0.1.0
Connected as mni
SQL>
SQL> with tabA As (
2 Select 1 As ida, 'Piet' As NomA, 'Sapin' As PrenomA From dual union all
3 Select 2, 'Gray', 'Davids' From dual union all
4 Select 3, 'MC', 'Donavan' From dual union all
5 Select 4, 'Karl', 'eric' from dual
6 ),
7 TabB As (
8 Select 1 As idb, 'Dobi' As NomB, 'Amina' As PrenomB From dual union all
9 Select 2, 'Sand', 'Celine' From dual union all
10 Select 3, 'Kolie', 'Romuald' From dual
11 ),
12 Dat1 As (
13 Select rownum cle, tabA.*
14 from tabA
15 ),
16 Dat2 As (
17 Select rownum cle, tabb.*
18 from tabB
19 )
20 Select cle, nomA, PrenomB
21 From Dat1 FULL OUTER JOIN Dat2 Using (cle)
22 /
CLE NOMA PRENOMB
---------- ---- -------
1 Piet Amina
2 Gray Celine
3 MC Romuald
4 Karl
SQL> |
Partager