Search notes:

Oracle: JOIN TO ONE

join to one enfroces Row Widening Only Queries (RWOQ) automatically.

select
   ‥
from
   oe.order_items                                                         oi
   JOIN TO ONE (oe.orders o, oe.product_information p, oe.customers c)

join to one was introduced in 26ai (23.26.2+)

Index