I'm working on a medium size project and have recently deployed the code to our client. When work began we agreed on Oracle 220.127.116.11 as the version and all my SQL statements work fine with this version. Now I drop the code to an Oracle 18.104.22.168 flavor of the database and by queries start having lots of problems.
The DBA there told me that INNER JOIN and LEFT OUTER JOIN ANSI queries will fail in 22.214.171.124.
My question is: Is this true? If so, not being a big PL/SQL expert, what can I replace the INNER JOIN AND LEFT OUTER JOIN keywords with? I need to fix this fast!