Suppose I have a table with 2 VARCHAR2(1)columns C1 and C2 and the
following 3 rows:
A B
A C
B A
For each value in columns C1 and/or C2, I need to report the count of
that value in each column such as:
Value #C1s #C2s
----- ----- -----
A 2 1
B 1 1
C 0 1
----- ----- -----
Total 3 3
I have written a PL/SQL procedure to do this. With Oracle 9.2 what is
the best method to do this with a single SQL query?