Can we use SQL Developer to generate Entity Relation (ER) diagram against existing Oracle or SQL Server Database? If it is Yes. Please give me some detail information about how to do it.
Thanks for your help.
You can import a data dictionary and then engineer that relational model to a logical one to get your ERD
Open the Model Explorer. Switch to your Relational Model. Use the File > Modeler > Import mechanism to connect to your database.
Select the objects you want imported.
Once you have relational, you can choose to engineer that to a logical.