There are more than a few joins in Oracle database and the same join can be written in many different ways. We …