Oracle SQL Developer to generate an ER diagram


The Oracle SQL Developer is a pretty powerful and efficient tool to connect with the Oracle database and perform some useful utilities like Write PLSQL, SQL, Import, Export data, SQL performance and generate Entity Relationship Diagram. We will discuss to generate an Entity Relationship Diagram (ERD) using the Oracle SQL Developer. It is very easy to generate ERD for the existing database table. Please follow the steps below –

Generate ERD

The Entity Relationship Diagram is one of the important component which explain the relationship between the various table used in the project. The Project should always has the ERD. Create a diagram for existing database schema or its subset as follows:

  • Launch the Oracle SQL Developer and Complete the Database Setup if it is not available.

  • Click File → Data Modeler → Import → Data Dictionary.

  • Click on Data Dictionary and it navigate to Data Dictionary Import Wizard Window.

  • Select the appropriate Database and Click on the Next button from the bottom of the screen.
  • Once above step completed then it navigate to Select Schema Screen.

  • Select the Schema DSAHU and Click on the Next Button.

  • Once clicked on the Next button then It navigate to select the entity(s) to generate the ERD.

  • Select all appropriate entities and click on Next button to generate the ERD. It navigate to the final screen.

  • Click on the Finish Button to view the generated ERD.

  • The ERD is displayed.

Download ERD

The user can download the ERD from the above SQL developer window. Please follow the steps below –

  • Click File → Data Modeler → Print Diagram → To Image File.

  • Select appropriate option like Image or PDF and Browse to and select the export file location.

  • Click Save. The file will save as selected path, Open the File and see the ERD.

Thanks a lot for reading this tutorial, Please provide your feedback using the comment box.

2 thoughts on “Oracle SQL Developer to generate an ER diagram”

Leave a Reply

Your email address will not be published. Required fields are marked *