What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]

by

This is an Oracle-specific notation for an outer join. It means that it will include all rows from t1, and use NULLS in the t0 columns if there is no corresponding row in t0.

In standard SQL one would write:

SELECT t0.foo, t1.bar
  FROM FIRST_TABLE t0
 RIGHT OUTER JOIN SECOND_TABLE t1;

Oracle recommends not to use those joins anymore if your version supports ANSI joins (LEFT/RIGHT JOIN) :

Oracle recommends that you use the FROM clause OUTER JOIN syntax rather than the Oracle join operator. Outer join queries that use the Oracle join operator (+) are subject to the following rules and restrictions […]

More Related Contents:

  1. Update statement with inner join on Oracle
  2. Splitting string into multiple rows in Oracle
  3. GROUP BY with MAX(DATE) [duplicate]
  4. Is there any function in oracle similar to group_concat in mysql? [duplicate]
  5. Can a foreign key be NULL and/or duplicate?
  6. What is the string concatenation operator in Oracle?
  7. Using an Alias in a WHERE clause
  8. How can I introduce multiple conditions in LIKE operator?
  9. Is there any boolean type in Oracle databases?
  10. SQL multiple columns in IN clause
  11. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  12. Dynamic Oracle Pivot_In_Clause
  13. How can I select from list of values in Oracle
  14. Convert Unixtime to Datetime SQL (Oracle)
  15. How to debug ORA-01775: looping chain of synonyms?
  16. Oracle Update Query using Join
  17. Generating dates between two dates
  18. SQL Command not properly ended?
  19. How to convert Rows to Columns in Oracle? [duplicate]
  20. SQL not a single-group group function
  21. Oracle: Combine multiple results in a subquery into a single comma-separated value [duplicate]
  22. SQL Keep getting error with ON UPDATE CASCADE
  23. Finding rows that don’t contain numeric data in Oracle
  24. When I call PreparedStatement.cancel() in a JDBC application, does it actually kill it in an Oracle database?
  25. How do I list all the columns in a table?
  26. How to check if a column exists before adding it to an existing table in PL/SQL?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  29. Exporting a CLOB to a text file using Oracle SQL Developer
  30. Oracle ‘Partition By’ and ‘Row_Number’ keyword

Leave a Comment