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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
|
SQL> create table e as select 'e1' id_e from dual;
Table created.
SQL> insert into e values ('e2');
1 row created.
SQL> create table f as select 'f1' id_f from dual;
Table created.
SQL> insert into f values ('f2');
1 row created.
SQL> insert into f values ('f3');
1 row created.
SQL> commit;
Commit complete.
SQL> create table s as select 's1' id_s from dual;
Table created.
SQL> create table l (id_l varchar2(2));
Table created.
SQL>
SQL>
SQL> select sum(nb_e) nb_e, sum(nb_f) nb_f, sum(nb_s) nb_s, sum(nb_l) nb_l from
2 (select
3 1 nb_e,
4 0 nb_f,
5 0 nb_s,
6 0 nb_l
7 from e
8 union all select
9 0,1,0,0
10 from f
11 union all select
12 0,0,1,0
13 from s
14 union all select
15 0,0,0,1
16 from l
17 );
NB_E NB_F NB_S NB_L
--------- --------- --------- ---------
2 3 1 0 |
Partager