Replies: 5 comments 3 replies
-
Does this SQL work in Oracle ? I think it needs to be converted to
|
Beta Was this translation helpful? Give feedback.
-
|
Sorry I missed to create a SQL that works: |
Beta Was this translation helpful? Give feedback.
-
|
Name the table orders instead of order, this will make this test easier :-) the full example: insert into orders values (1, 1); SELECT o.orderno, c.customername SELECT o.orderno, c.customername |
Beta Was this translation helpful? Give feedback.
-
|
You should run this query in ivorySql: |
Beta Was this translation helpful? Give feedback.
-
|
I'm a fan of writing sql syntax the older way and therefore am a +1 for adding the outer join systax as an upcoming feature: |
Beta Was this translation helpful? Give feedback.


Uh oh!
There was an error while loading. Please reload this page.
-
Will you fix so that Oracle outer join syntax will work?
Or does it already work? (it does not work for me)
Example:
SELECT o.orderno, c.customername
FROM order o, customer c
WHERE o.customerid = c.customerid (+);
It should become:
SELECT o.orderno, c.customername
LEFT OUTER JOIN o.customerid = c.customerid (+);
This would make a huge inpact for old system transforming to IvorySql from Oracle db.
Beta Was this translation helpful? Give feedback.
All reactions