Imagine, how many different outputs you can generate from one ERD! The generated page will contain all table columns, but only those with comments will be shown in the graphics. Quick example: if you change the property display to none for class. Via CSS styles - generate HTML code for everything and use CSS styles to show or hide items.Via scripting - generate HTML code for desired items only.
#ER DIAGRAM IN ORACLE SQL DEVELOPER HOW TO#
There can be at least two ways how to affect the final visualization Grey items represent columns with comments. See the web page with the generated diagram. In result, you can achieve useful visualizations and quickly recognize important items in your ER diagrams. If you want to apply some condition, for example set style only to attributes that match some criteria, edit the last two functions: Redefinition of CSS styles should be very easy, just change the classic CSS properties in the code. To change the structure or styles, edit macro DiagramToWebPageMacro. The page contains CSS styles, HTML and SVG elements.
Open the generated HTML page to see its structure.
Fortunately, we can quickly modify the imported macro and set CSS style to items that need to be highlighted. In Toad Data Modeler such possibility is not available - because there can be plenty of similar requirements. Let's say we want to somehow recognize table columns with comments. Double click the page to open it in your browser. Then open your model and click Macros | Diagram to Web Page.īy default, the page will be generated to C:/ directly and named by model+workspace name, for example C:/Videorental_All Items.html. To generate the web page, download package DiagramToWebPage and import it into Toad Data Modeler You can see Toad Data Modeler and a web browser with diagram that looks very similar to the ERD produced by Toad Data Modeler. In this article I am going to show you how to generate diagram to a web page and how to visualize only specific items.