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!

NATURAL JOIN never fails?

3230015Sep 30 2016 — edited Nov 11 2016

Every time someone joins 2 tables in the HR schema provided by Oracle with Database 12c using NATURAL JOIN in the simplest SQL queries starting by "SELECT * ", it always returns a result. The query never fails nor comes out empty.

I wander... What is happening behind the scenes? Is Oracle 12c resolving the query each time across the HR schema or what?

This post has been answered by mathguy on Sep 30 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 9 2016

Added on Sep 30 2016

16 comments

2,018 views