If you head on over to http://docs.oracle.com/en/database/ you’ll be both amazed and dismayed by the volume of documentation you can find about the database. If you’re a seasoned Oracle professional, then you probably dont think twice about finding PIVOT examples in Chapter 18 of the Data Warehousing guide
But for the novice, whether it be DBA or Developer, it can be a bit overwhelming. One resource that you might find a useful addition to your navigation of the Oracle universe, is the interactive quick reference site.
You’ll see a screen like this:
You can then click on the various tabs to get more information, plus useful links to other resources that might be useful. For example, the multi-tenant tab gives you an overview of the facility