PaulB-TheOneAndOnly (9/4/2010)
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
I would, but I really should work with what we are using on the government contract. Depending on some of the other projects they may have work, I may try to bring in SQL Server. When working with moving data between databases (ETL), SSIS may come in handy. For one process there is currently over 60,000 lines of PL/SQL code. Unfortunately, I may not see that code for a while, as I believe it is proprietary to the subcontractor on that other project that is still in development.