Previous Next

Oracle Objects Editors

dbForge Studio for Oracle provides an opportunity to create and edit objects using visual objects editors. So there is no need to type SQL code to create or edit objects as this can be done simply from the context menu of the corresponding object (node) in Database Explorer.

There are objects editors for the following object types: tables, views, packages, procedures, functions, triggers, user types (array types, object types, table types), sequences, materialized views, materialized view logs, synonyms, clusters, database links, XML schemas.

Designing tables

Table Designer is a universal tool for creating and editing tables visually. The tool's grid is a perfect space for performing all actions related to working with table structure. It allows managing columns and specifying major properties without opening extra windows. You can add and remove primary keys, add comments, define collations.

To simplify creating columns, the application provides the heuristics feature. When you enter frequently-used column names, such as ID, Name, Price, etc, or when these words are a part of the name, the application will automatically set the data type that corresponds to the name.

The table DDL is displayed under the grid and all changes are reflected in it immediately. If you are editing an existing table, you can see all changes you make in the application SQL editor. It's enough to perform the changes in the visual grid and press the Script changes button - and they will be displayed in new SQL document. If you want, you can copy them to clipboard directly from Table Designer.

Working with object editors

dbForge Studio for Oracle supplies visual object editors for various objects. Use them to create, modify, and update your database objects.

The View editor allows editing query text of the view, column names, and some other properties. Text and Data tabs let you observe the view code and data.

Sequences

This editor provides all options for generating unique keys in one tab. You can view the code of your sequence in the other tab.

Materialized Views

This editor allows creating materialized view visually. It has a number of tabs for setting options, defining indexes, constraints, etc depending on the type of the materialized view.

Materialized View Logs

This editor provides full set of options to create materialized view logs. Materialized view logs are crucial for quick refreshment of materialized views, so use intuitive dbForge Studio editor that will let you create them in several clicks.

Synonyms

Use one tab to define all synonym properties. You can switch to the Text tab to view object code.

Database Links

Create and edit database links to access other database servers using visual editor. Complete list of adjustable settings lets you customize the links exactly to your needs.

XML Schemas

Create and modify XML schema definitions in visual editor. General and Advanced tabs with various options will let you customize the object.

Editors for other database objects

Editors for packages, procedures, functions, triggers, user types provide SQL text field with the corresponding sample code for creating new object. To modify an object, you should edit the code.

Availability in editions of dbForge Studio for Oracle

Features

Pro

Std

Exp

Objects Editors
Yes
Yes
Yes