sqlines icon indicating copy to clipboard operation
sqlines copied to clipboard

IN Conversion (Oracle -> postgreSQL)

Open ZhenNan2016 opened this issue 2 years ago • 0 comments

Hi Excuse me. Recently, I have been using sqlines to convert Oracle SQL statements to postgreSQL statements. I have found that the functions under Linux are different from those online. The differences are as follows:

  1. Online tools: http://www.sqlines.com/online
    select * from a,b where a.id=b.id(+); => select * from a left outer join b on a.id=b.id;
    select * from a,b where a.id(+)=b.id => select * from a right outer join b on a.id=b.id;

Both statements are expected.

  1. Command line tools: sqlines master/bin/sqlines64
    select * from a,b where a.id=b.id(+); => select * from a,b where a.id=b.id(+);
    select * from a,b where a.id(+)=b.id; = > select * from a,b where a.id(+)=b.id;

It seems that there is no conversion to left join and right join. Why is this?

Now,my core needs are as follows: I hope to use the command line tool sqlines64, which has the same functionality as using online tools. What do I need to do?

ZhenNan2016 avatar Mar 28 '23 10:03 ZhenNan2016