Reporting for duty!Īt some point someone is going to ask your for a ‘data dictionary report.’ You might think you know what this is, or maybe you have seen one before. If you’ve gone through all this and you still don’t see your model diagrams, right-mouse-click on the model in the browser tree, and select ‘Show Diagram.’ This will activate the diagram in the SQL Developer interface as a new document. Why ALT+TAB when you can do everything in your IDE? Your model will then be displayed in SQL Developer. Or you could create a new physical model by importing a ‘Data Dictionary.’ This is code for, ‘reverse engineer an existing Oracle database.’ You can use the File – Data Modeler – Open dialog to open any of your models. Once opened, you’ll see a new ‘Browser’ panel beneath your Connections. To open the Data Modeler inside of SQL Developer, navigate to the View menu, and activate the Data Modeler Browser, like so – Running the Data Modeler inside of SQL Developer It’s not like we hide it, but we kind of hide it. I’m going to go out on a limb and guess that most people who use SQL Developer do not realize it has a fully-baked data modeling tool built into it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |