This site is a collection of Oracle SQL tips for beginners. Especially in the following areas:



  • SQL*Plus  — getting the most from Oracle’s command line interface


  • SQL99  —a different (newer and better) query syntax
  • Normal (equi) join — Compare old and new syntax for the most common join type
  • Outer join — Compares old and new syntax for the outer joins
  • Natural join — New syntax for normal (equi) join on all columns with matching names.
  • Cross join — New syntax for cartesian joins (no join clause)