Philipp Salvisberg @salvis.com · May 1 The new features guide for Oracle AI Database 23.26.2 is out: docs.oracle.com/en/database/... One interesting addition is the join_to_one clause, which uses integrity constraints to simplify joins.
6 likes 2 replies
?
Replies
oh interesting. so if the FK guarantees one row it just skips the join entirely? curious how it handles constraints that exist but aren't validated
Looks like a tweak of little value that can introduce problems and is unlikely to have been implemented completely and consistently. e.g. (to pick a trivial example): What happens if you want to join emp to emp then select the dname from both "join to one" dept? Is it part of the latest stanrdard?