

If you add a table to a diagram, foreign key relations with other tables on the diagram will automaticallybe included. Toremove a line, select it and press the Delete key. You canmove the line to another element by selecting the line and moving the selection point up or down. A line will be drawn between the 2 elements of the objects. You can do this for all objecttypes.Īdding relationsTo add a relation between 2 objects, click on the icon of an element of the source object, and drag it tothe element of the target object. You can also hide the complete key orindex section.īy default all items will be displayed, but if you right-click on an object and select Set as default, thevisible items will apply to all objects added to a diagram in the future. For a table you canselect which items of a column, key or index you want to show. Hereyou will see a submenu with all items that are applicable for the selected object. Showing and hiding itemsTo show or hide a specific item of a diagram object, right-click on it and go to the Items submenu. This will only affect the diagram, and the database object will not be dropped. To delete an object from the diagram, press on the X at theupper-right of the object. To resize a diagramobject you can drag an edge or a corner. To move a diagram object, click on the title bar and drag it to the new location.

You can drag & drop multiple objects at once. To add a database object to the diagram, drag it from the ObjectBrowser into the Diagram Window. Right-clickingon an object provides access to all object functions, and double-clicking on an object will invoke thedefault action for the object type.Ģ.1 Creating a diagramTo create a new diagram, select the Diagram Window from the New submenu in the File menu. For large diagrams you can add additional structureby including object groups.Ī diagram can be used for documentation purposes, but can also serve as a workspace. Foreign keyrelations between tables are automatically included. You can add all relevant object types to a diagram, and include the relations between them. This wayyou can easily visualize (a part of) the database objects of your application or project and their relations: Diagram WindowThe Diagram Window allows you to create a graphical representation of a selection of objects. For a detaileddescription of previous features, see the PL/SQL Developer 6.0 Users Guide.Ģ. IntroductionThis document describes the most important new features in PL/SQL Developer 7.0. GRID ENHANCEMENTS.31ġ4.1 OBJECT GRID FILTERS.3114.2 FIND FUNCTION. EDITOR ENHANCEMENTS.2913.1 GLOBAL NAVIGATION. SESSION WINDOW ENHANCEMENTS.2712.1 SESSION FILTERS.2712.2 CONCATENATE HINT. 2310.3 ALTERNATE GRID ROW COLORS.2410.4 GRID COLUMN TOTALS.2410.5 GRID SELECTION INDICATOR.2510.6 EXCEL EXPORT. SQL WINDOW ENHANCEMENTS.2310.1 MULTIPLE STATEMENTS.2310.2 GRAPH WINDOW.
#Twitch turbo code#
219.4 SUBSTITUTION VARIABLES.219.5 REFACTORING.219.6 CODE CONTENTS LAYOUT. 209.1 NAMING CONVENTIONS.209.2 HIGHLIGHT VARIABLES.219.3 SAVE WINDOW STATE PREFERENCE. 62.2 SAVING AND OPENING A DIAGRAM FILE.82.3 UPDATING A DIAGRAM.8ģ.
