Another gem found off of the oracle-l list is this page, which offers a nice breakdown of the differences between the various RDBMS implementations (Oracle, Postgres, MySQL, etc.) in terms of their SQL implementations.
Interpreting Query Plans
Someone one the oracle-l list posted a link to a nice breakdown of everything about Oracle's "explain plan" output. Very nice read.
The Four Options of the SHUTDOWN
One thing that's always good to know is that there are actually 4 different options to the Oracle SHUTDOWN command. They are:NORMALTRANSACTIONALIMMEDIATEABORTNow allow me to cover the differences.NORMALThis is the default option for the SHUTDOWN command. Once a SHUTDOWN NORMAL is issued, no new user connections will be allowed. However,... [Read More]
Truth, Justice, and ...
The Worth of Certifications
NOTE: Howard has since taken his site offline while he finds a suitable webhost, so the first link probably won't workHoward Rogers recently touched on the knowledgeset (or lack thereof) of some interviewees with OCPs. We've all heard this before, and the common theme is that just because someone managed... [Read More]