Staying in the flowering field is obvious; the Oracle documentation set is always the first and best place to start. Check this.
Edit
The SS64 site is clear, but very outdated. Its latest syntax is set 9i, two major temp releases. It is also not complete. For example, the WITH clause is not mentioned on the SELECT page, which was a very useful feature introduced in 9i.
, ( ). Oracle.