Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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 on Oct 6 2007
Added on Sep 7 2007
23 comments
5,286 views