Convert old Oracle join style to ANSI standard

Moderator: NorbertKrupa

Post Reply
User avatar
fsalvelt
Intermediate
Intermediate
Posts: 54
Joined: Sun Mar 18, 2012 1:34 am

Convert old Oracle join style to ANSI standard

Post by fsalvelt » Wed May 16, 2012 12:53 pm

Hi folks,

Is there a tool that would help us rewrite a ton of code written in Oracle? There are many outer joins written using the old (+) symbol instead of the ANSI standard. Otherwise we're going to be re-writing a lot of code :(

Thank you
Thank, Fred

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: Convert old Oracle join style to ANSI standard

Post by jpcavanaugh » Mon May 28, 2012 5:41 pm

I have not tried it but this looks like it might be a promising start.

http://www.dpriver.com/blog/list-of-dem ... ant-joins/

Post Reply

Return to “New to Vertica Database Administration”