Re: Problem with Decode fuction

> Consider this:
>
> select decode(count(1),1,0,null) from DUAL
> where exists (select 1 from my_table
> where field 1 = 'STRING1' ......... )
>
> Case instead of Decode is easier to read if your version permits it.

What about this one?:

select decode(count(1),1,0,null) from DUAL where exists (select 1 from pm_ticketroutinglinks

              where classification = 'PROCUREMENT_NEW' AND
                    component_type = 'CLIENT_HARDWARE' AND
                    component      = 'PC_DELL');

Thanks
Tom Received on Sun Sep 28 2003 - 14:43:31 CDT