Lynn Pettis (8/31/2010)
Found some resources, SQL Reference Guide for Oracle 10g. Guess what, Oracle actually has CTE's, they just don't call it that in the reference manual.Having access to the reference manual is showing me that I can actually use some of the things I have learned here on SSC.
Still looking forward to seeing if I can push for moving toward SQL Server, but we'll have to wait and see.
Now, if they would just get me access to an instance of Oracle.
Way to go Lynn.
All Oracle documentation is free and public, if interested in Ora10g please check http://www.oracle.com/pls/db102/portal.all_books
In regards to licensing, Oracle is free for educational purposes so you can just go to Oracle and download a full version of it. If 10g is your target go for Ora10gR2
Having said that, I would personally go for Ora11g
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.