Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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	Next>	Last>>