Skip to Main Content

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!

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

Waqar waqar

how can i solve ???????????

1 - 1
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,412 views