Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 22 Apr 2005 @ 19:17:27 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Teradata and Oracle SQL
From:   Dempsey, Mike

If you have SQL Assistant you can look at a reasonably complete list of Oracle and Teradata statements in the syntax files. (oracle.syn and teradata.syn, or oracle_sp.syn and teradata_sp.syn for the Stored Procedure language statements.)

These are simple text files , but since many statements span multiple lines they are not always easy to read.

If you have Terdatat and Oracle databases that you can connect to I would suggest connecting to both (2 copies of SQL Assistant) and bringing up the Query Builder in each. That will give you an easy to read list of statements together with the examples.

This only gives you a list of the statements and a single example of each - not a detailed comparison of any given statement.

If you need more detail both companies have the full syntax available on their web sites.

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023