Visual Object Editors for Oracle

Visual Object Editors will help you modify database objects from the context menu as easily as possible.

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 database objects in Oracle 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 allows for effortless managing of columns, specifying major properties, adding and removing primary keys, adding comments, and defining collations. There are several ways to show tables in Oracle, among which you will surely find your favorite.

The creation of columns within the application is convenient as well as time-saving: when you enter frequently-used column names, such as ID, Name, or Price, the application will automatically set the corresponding data type.

Besides, all changes you make in the visual grid are reflected in the table DDL located below. So, if you are editing an existing table, you can see all changes you make in the application SQL editor.

Designing a table in a convenient grid of 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.

Working and editing views with the help of the view editor

Sequences

You can easily create, edit, and delete sequences with dbForge Studio for Oracle. The primary purpose of sequences is to generate unique keys. With the editor, you can have all options for generating unique keys in one tab. You can view the code of your sequence in the other tab.

Views

A database view is a subset of the actual data sorted and displayed in a particular way. Views contain no data on their own, but retrieve it from the underlying tables when queried. They can join and simplify multiple tables or views into one virtual table. With Studio for Oracle, you can easily create a view, modify it, or drop as well as retrieve and alter data in the underlying tables. If any changes are necessary, go to the Editor and alter the text of a query.

Displaying a view within the tab of the visual editor

Materialized Views

A materialized view, or snapshot, is a database object that contains the results of a query. This editor allows for creating materialized views visually. It has a number of tabs for setting options, defining indexes, constraints, and partitioning settings depending on the type of the materialized view.

Setting main options for a materialized view with Materialized View Editor

Materialized View Logs

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

Creating a materialized view with the help of the visual editor

Synonyms

A synonym is an alternative name for a schema object. The use of synonyms can greatly boost security by masking the name and owner of a database object as well as providing location transparency. In the visual editor, use one tab to define all synonym properties. You can switch to the Text tab to view object code.

Defining synonym properties in the visual editor tab

Database Links

A database link is a pointer that defines a path between two physical database servers. Visual editor enables you to create and edit database links to access other database servers without extra effort. A complete list of adjustable settings lets you customize the links exactly to your needs.

XML Schemas

XML Schemas are used to describe and validate the structure and the content of XML data. With the help of visual editor, you can create and modify XML schema definitions. General and Advanced tabs with various options will let you customize the object.

Editors for other database objects

Editors for other database objects, including packages, procedures and functions, triggers, and user types provide SQL text field with the corresponding sample code for creating a new object. To modify an object, you should edit the code depending on your needs.

Editing the code of a function through the visual editor

Conclusion

Within dbForge Studio for Oracle, you get the opportunity to quickly and effortlessly edit and modify your database objects visually in a convenient environment. With this option supported for the majority of objects in Oracle, there is now no difficulty in creating an object, specifying the properties, customizing the options, and modifying the code. Apart from these, dbForge Studio for Oracle offers many other database management tools and features, for example, the Find Database Objects functionality, provided to you by default.

Availability in the editions of dbForge Studio for Oracle

Feature

Enterprise

Professional

Standard

Express

Visual editors for schema objects