Re: SQL Plus Reporting

Does something like this satisfy your needs: select

    sum(decode(table.column1,'U',1,0)) U_values,
    sum(decode(nvl(table.column1,'NULL'),'NULL',1,0)) NULL_values,
    sum(decode(table.column1,'Z',1,0)) Z_values

    table;

Jeff Cohen
jcohen_at_breze.com Received on Tue Sep 01 1998 - 21:57:49 CDT