Does Oracle's connection have a full connection?

Oracle's connection has a full join; the connection in Oracle can be divided into inner join, outer join and full join. The query result of the full join is the union of the query results of the left outer join and the right outer join. The syntax is: "full join...on..."; When a row has no matching row in another table, the select list column of the other table contains null values.

The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.

Oracle’s full join

Joints in Oracle can be divided into inner join, outer join, and full join

The syntax is full join ... on ...,

The query result of the full join is the union of the query results of the left outer join and the right outer join. Even if some records cannot be related, some records can be The information is queried:

Produces M N result sets, lists all of the two tables, and replaces those that do not meet the conditions with null values.

Examples are as follows:

Full join: A complete outer join returns all rows in the left and right tables. When a row has no matching row in another table, the other table's select list column contains null values. If there are matching rows between tables, the entire result set row contains the data values ​​from the base table.

select * from book as a full outer join stu as b on a.sutid = b.stuid

The results are as follows:

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of Does Oracle's connection have a full connection?. For more information, please follow other related articles on the PHP Chinese website!