Translating Teradata SQL to Oracle SQL
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 22 Jan 2009 14:07:36 -0800
Message-ID: <a9c093440901221407v7040d4efvb2da133e052ab540_at_mail.gmail.com>
Does anyone know of any tools/scripts/parser that can translate Teradata SQL to Oracle SQL. Specifically I'm looking for something that supports changing
"GROUP BY <ordinal>" to "GROUP BY <expression>" as Oracle does not support ordinal references in a group by.
Date: Thu, 22 Jan 2009 14:07:36 -0800
Message-ID: <a9c093440901221407v7040d4efvb2da133e052ab540_at_mail.gmail.com>
Does anyone know of any tools/scripts/parser that can translate Teradata SQL to Oracle SQL. Specifically I'm looking for something that supports changing
"GROUP BY <ordinal>" to "GROUP BY <expression>" as Oracle does not support ordinal references in a group by.
Thanks in advance.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 22 2009 - 16:07:36 CST