Skip to Main Content
Forums

Oracle Database Discussions

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 debug failed inner join ?

user575089Jun 8 2016 — edited Jun 8 2016

Hi,

I have a big sql query  which has inner joins with multiple tables.


I don't get any records for a specific  condition in where clause.  How do I  debug which inner join is failing to produce records ?

Is there any tools which could help which inner join is failing ?

Thanks for your time.
This post has been answered by Pavan Kumar on Jun 8 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2016
Added on Jun 8 2016
#general-database-discussions
19 comments
3,585 views