IvorySQL
IvorySQL copied to clipboard
Oracle special outer join syntax not supported
Enhancement
Oracle has a special syntax for outer join that is not supported in ivorySQL.
The syntax looks like this:
SELECT o.orderno, c.customername
FROM orders o, customer c
WHERE o.customerid = c.customerid (+);
This command is exactly the same as:
SELECT o.orderno, c.customername
FROM orders o
LEFT OUTER JOIN customer c
ON o.customerid = c.customerid;
It is possible to continue outer joins on more tables.
This is very common syntax in old Oracle applications and this is enhancement needed in order to migrate to ivorySQL for many such systems.
Ps. Thanks for your excellent work :-)