Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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

User_1871Jun 13 2022

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.”

Comments
Post Details
Added on Jun 13 2022
0 comments
37 views