I am an Oracle report writer with SQL and PL/SQL experience. I am in the process of moving to a job that has a Teradata database (no Oracle). I know that there are differences between the two versions of SQL, and I would like to use my Oracle background to help in the transition. Is there a document that talks about the differences between Oracle SQL and Teradata SQL? Can you recommend any white papers or books or other resources that compare the two SQL versions and give specific examples? Any help is appreciated.
Thanks in advance.
I've never used the Teradata RDBMS before. So I asked myself how I would handle this if I were in your shoes. The first thing to know is that there is a lot of compatibility between SQL statements in Oracle and Teradata. So many of your SQL statements will work. Both Oracle and Teradata are compliant with the entry-level SQL-99 standard. Outside of basic SQL statements, you will find that Oracle and Teradata implement SQL a little differently. If you know how to write your SQL statement in Oracle, then all you need to do is to look up the correct syntax in your Teradata documentation. I was not able to find any white papers that give a nice comparison between the two. Also, you can look on Amazon.com for books like Teradata SQL. I found
Unleash the Power
by Coffig and Larkins. Since you know Oracle's SQL, it should be pretty easy for you to pick up Terdata's SQL.
Dig Deeper on Oracle and SQL
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.