Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle RIGHT JOIN to HiRDB

SQLWays changes select statement with right join to select statement with left join.

Oracle:

select * from t1 right [outer] join t2 on t1.c1 = t2.c1;

HiRDB:

select t1.*, t2.* from t2  left [outer] join t1 on t1.c1 = t2.c1;

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