Use Nested Loops.
Usage : use_nl(A B)
This hint will ask the engine to use nested loop method to join the tables A and B. That is row by row comparison.
The hint does not force the order of the join, just asks for NL.
In this page (written and validated by A. Gawali) you learned about Oracle Hints . What's Next? If you are interested in completing Oracle tutorial, your next topic will be learning about: Oracle Packages.