"RK" <rekaben@yahoo.com> wrote in
news:1118245120.906496.257230@f14g2000cwb.googlegr oups.com:

>
> Hi, can someone help me, please?
>
> I have a big table with two different fields f1 and f2, there are many
> many different combinations of these two fields values.
>
> Now I need to do this:
>
> select f1, count(*) from table group by f1;
> select f2, count(*) from table group by f2;
>
> Each count may take long time. Can I run one query on the two fields,
> and still get separate total counts of the different field-values, with
> SQL*Plus only?
>
Yes, but neither query above does what you say you want.
Both will give the same value for count.
You might want to try using the DISTINCT qualifier.