Oracle: What does `(+)` do in a WHERE clause?

by

Depending on which side of the “=” the “(+) is on, it denotes a LEFT OUTER or a RIGHT OUTER join (in this case, it’s a left outer join). It’s old Oracle syntax that is sometimes preferred by people who learned it first, since they like that it makes their code shorter.

Best not to use it though, for readability’s sake.

More Related Contents:

  1. How do I limit the number of rows returned by an Oracle query after ordering?
  2. When do I need to use a semicolon vs a slash in Oracle SQL?
  3. LISTAGG in Oracle to return distinct values
  4. Fetch the row which has the Max value for a column
  5. Oracle SQL: Update a table with data from another table
  6. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  7. Select count(*) from multiple tables
  8. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  9. Concatenate and group multiple rows in Oracle [duplicate]
  10. Oracle SQL escape character (for a ‘&’)
  11. SQL Error: ORA-00933: SQL command not properly ended
  12. CASE vs. DECODE
  13. Convert a string date into datetime in Oracle
  14. DATEDIFF function in Oracle [duplicate]
  15. WHERE IN condition not accepting String value
  16. Check if current date is between two dates Oracle SQL
  17. Benefits Of Using SQL Ordinal Position Notation?
  18. Unordered results in SQL
  19. Oracle Dynamic Pivoting
  20. create custom function for date difference excluding weekends and holidays in oracle sql
  21. What is it exactly a BLOB in a DBMS context
  22. Custom Order in Oracle SQL
  23. How do I list all tables in a schema in Oracle SQL?
  24. oracle sql: update if exists else insert [duplicate]
  25. Compare Strings ignoring accents in SQL (ORACLE)
  26. Search an Oracle database for tables with specific column names?
  27. ORA-01861: literal does not match format string
  28. Query a Table’s Foreign Key relationships
  29. Backup SQL Schema Only?
  30. IN vs OR of Oracle, which faster?

Leave a Comment