Question

Using Oracle Proprietary join syntax, which operator would you use after one of the column names in the WHERE clause when creating an outer join?

a.*
b.(+)
c.=
d.+

Answer 1

In Oracle Proprietary join syntax, the operator used to create an outer join is the (+) operator, which is placed after a column name in the WHERE clause to specify that it's an outer join, ensuring the inclusion of all rows from the specified side of the join even if there are no matches in the joined table.

The answer is option ⇒d.+

Step-by-step explanation:

When using Oracle Proprietary join syntax to create an outer join, you use the (+) operator after one of the column names in the WHERE clause. This indicates that it is an outer join, which will include all rows from the specified side of the join, even if there is no matching row in the joined table.

For example, if you want to perform a left outer join between two tables, employees and departments, where each employee may or may not have a department, you would use the following syntax:

• SELECT e.name, d.name
• FROM employees e, departments d
• WHERE e. department_id = d. department_id (+);

In this query, the (+) operator tells Oracle that it should return all employees, including those who do not have a matching department. Without the (+) operator, it would be a standard inner join, possibly excluding some employees.

The answer is option ⇒d.+