Forum Stats

  • 3,875,570 Users
  • 2,266,947 Discussions
  • 7,912,257 Comments

Discussions

Update the docs: References to ‘(+)’ notation should be updated to use explicit joins

The 21c docs use the ‘(+)’ notation. The docs should be updated to use explicit joins.

Example:

5.3.1.2 Unnesting Results of Collection Queries

https://docs.oracle.com/en/database/oracle/oracle-database/21/adobj/operations-on-collection-data-types.html#GUID-162C0E09-FE50-48CB-957F-F7B424BEC33A

“To get rows for departments with or without employees, you can use outer-join syntax:

Copy
SELECT d.dept_no, e.* 
  FROM department_persons d, TABLE(d.dept_emps) (+) e;

The (+) indicates that the dependent join between department_persons and e.dept_emps should be NULL-augmented. That is, there will be rows of department_persons in the output for which e.dept_emps is NULL or empty, with NULL values for columns corresponding to e.dept_emps.”

User_1871
1 votes

Active · Last Updated