Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table a (
  id1 int,
  id2 int
)
create table b (
  id int,
  xxx int
)
create table c (
  id int,
  yyy int
)
explain plan set statement_id = 'test' for
SELECT *
FROM a, b, c
WHERE
b.id (+) = a.id1
AND b.xxx = c.yyy
AND c.id (+) = a.id2
select *
from table(dbms_xplan.display(null, 'test'))

PLAN_TABLE_OUTPUT

Plan hash value: 1502482080

----------------------------------------------------------------------------

| Id  | Operation           | Name | Rows  | Bytes | Cost (%CPU)| Time     |

----------------------------------------------------------------------------

|   0 | SELECT STATEMENT    |      |     1 |    78 |     6   (0)| 00:00:01 |

|*  1 |  HASH JOIN          |      |     1 |    78 |     6   (0)| 00:00:01 |

|*  2 |   HASH JOIN         |      |     1 |    52 |     4   (0)| 00:00:01 |

|   3 |    TABLE ACCESS FULL| A    |     1 |    26 |     2   (0)| 00:00:01 |

|   4 |    TABLE ACCESS FULL| B    |     1 |    26 |     2   (0)| 00:00:01 |

|   5 |   TABLE ACCESS FULL | C    |     1 |    26 |     2   (0)| 00:00:01 |

----------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

   1 - access("B"."XXX"="C"."YYY" AND "C"."ID"="A"."ID2")

   2 - access("B"."ID"="A"."ID1")

Note

-----

   - dynamic statistics used: dynamic sampling (level=2)

explain plan set statement_id = 'test1' for
select *
from a
  left join b
    on b.id = a.id1
  left join c
    on c.id = a.id2
    and b.xxx = c.yyy
select *
from table(dbms_xplan.display(null, 'test1'))

PLAN_TABLE_OUTPUT

Plan hash value: 2316364204

----------------------------------------------------------------------------

| Id  | Operation           | Name | Rows  | Bytes | Cost (%CPU)| Time     |

----------------------------------------------------------------------------

|   0 | SELECT STATEMENT    |      |     1 |    78 |     6   (0)| 00:00:01 |

|*  1 |  HASH JOIN OUTER    |      |     1 |    78 |     6   (0)| 00:00:01 |

|*  2 |   HASH JOIN OUTER   |      |     1 |    52 |     4   (0)| 00:00:01 |

|   3 |    TABLE ACCESS FULL| A    |     1 |    26 |     2   (0)| 00:00:01 |

|   4 |    TABLE ACCESS FULL| B    |     1 |    26 |     2   (0)| 00:00:01 |

|   5 |   TABLE ACCESS FULL | C    |     1 |    26 |     2   (0)| 00:00:01 |

----------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

   1 - access("C"."ID"(+)="A"."ID2" AND "B"."XXX"="C"."YYY"(+))

   2 - access("B"."ID"(+)="A"."ID1")

Note

-----

   - dynamic statistics used: dynamic sampling (level=2)