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;

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.