Oracle Joins – Comparison between conventional syntax VS ANSI Syntax

by

If your 200+ packages work as intended with “old fashioned” syntax, let it be.
SQL will not start to perform better after migration to ANSI syntax – it’s just different syntax.

All that being said, ANSI syntax is cleaner – you are not going to normal join if you forget (+) in some multi-column outer join.

In the past there were some bugs with ANSI syntax but if you go with latest 11.2 or 12.1 that should be fixed already.

Of course, you know your environment and priorities better – as SchmitzIT said – ANSI syntax is part of SQL standard and it would help when going to use some other RDBMS product.

More Related Contents:

  1. Is it possible to output a SELECT statement from a PL/SQL block?
  2. Using ‘case expression column’ in where clause
  3. REGEX to select nth value from a list, allowing for nulls
  4. How to use BOOLEAN type in SELECT statement
  5. Conditional SUM on Oracle
  6. How to get the last row of an Oracle table
  7. Using pivot on multiple columns of an Oracle row
  8. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  9. Pivoting of data using two columns
  10. INSERT SELECT statement in Oracle 11G
  11. Update with Join query in Oracle
  12. Sleep function in ORACLE
  13. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  14. Nth max salary in Oracle
  15. Display names of all constraints for a table in Oracle SQL
  16. Autoincrement in oracle to already created table
  17. Oracle 11g – Check constraint with RegEx
  18. How to use a dynamic parameter in a IN clause of a JPA named query?
  19. The network adapter could not establish the connection – Oracle 11g
  20. Oracle string aggregation
  21. Oracle date “Between” Query
  22. ORA-01861: literal does not match format string
  23. Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it
  24. Subtracting Dates in Oracle – Number or Interval Datatype?
  25. Query a Table’s Foreign Key relationships
  26. How to call Oracle MD5 hash function?
  27. Oracle RAC and sequences
  28. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  29. Insert into from CTE
  30. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?

Leave a Comment