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!

join if not null

499230Apr 29 2008 — edited Apr 29 2008
Hi

I have select like

SELECT A.*
FROM dat A , TYP B
WHERE
( in where cluse i have to specify 3 columns if data is present . If any of the column is null then dont use that column in join )
Is it possible write it in single SQL or need to use PL/SQL?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2008
Added on Apr 29 2008
7 comments
1,115 views