Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Style JOIN Operator (+) to HiRDB
SQLWays converts (+) to LEFT JOIN.
Oracle:
SELECT * FROM TO1, TI2 WHERE TO1.C1=TI2.C1(+) AND TO1.C1=expr1 AND TO1.C2=expr2 AND TI2.C1(+)=expr3 AND TI2.C2(+)=expr4;
HiRDB:
SELECT * FROM TO1 LEFT OUTER JOIN TI2 ON TO1.C1 = TI2.C1 AND TI2.C1=expr3 AND TI2.C2=expr4 WHERE TO1.C1 = expr1 AND TO1.C2 = expr2;