Skip to Main Content

How to "where any of(b,c,d,e,f,g,h..) is null" with SQL(not PL/SQL)

426850Sep 7 2007 — edited Sep 8 2007
With the combinations of case, decode and coalesce function this can be done via pl/sql function, but is it possible to do it with SQL(any similar operator for this need I mean).

This need is because this is a report and the data processed is large so if this can be done within SQL engine it may help with performance.

Best regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Oct 6 2007
Added on Sep 7 2007
23 comments
4,977 views