Navigating the world of Oracle database documentation

If you head on over to 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 Smile

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.

Just head on over to

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



Expunging the Expand all

I’m sure many people love the collapsed form of the Oracle documentation, with the associated “Expand All” function…

Me….I hate it.  The first thing I do is click “Expand All” and “Hide Navigation” to make it look like a standard html page and the Oracle documentation of old..

If you’re a dinosaur like me, then you can permanently turn it off – simply go into the “dcommon/js” folder and rename “doccd.js” to something else.