sqlines
sqlines copied to clipboard
IN Conversion (Oracle -> postgreSQL)
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:
- 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.
- 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?