Synonym Editor
Use the Synonym Editor to view or create synonyms.
|
About synonym Objects |
A synonym is an alternate name for a table or view. A synonym can be private (for use only by its creator) or public (for use by any user). Primarily, synonyms enable multiple users to reference an object without adding the schema as a prefix to the object. They can also allow different applications to reference the same object using different names. You can make synonyms for the following database objects:
The characteristics and usage of this database object are described in Oracle documentation. |
Ways to Open The Synonym Editor
| Icon | Action | Description |
|---|---|---|
| |
From the Main Menu View Menu | Visual Object Editors | Synonym Editor |
Open the Synonym Editor. |
 |
From DB Navigator or Find objects Dialog Right click on a Synonym object and click Open. |
Open the selected object in the Synonym Editor. |
Table Editor
Use the Table Editor to create, alter, or define tables. Functionality includes:
- Adding and deleting columns
- Defining column properties
- Setting tablespace storage parameters
- Setting partitioning properties
Although you won’t need to type any PL/SQL code when editing tables in SQL Navigator, you should be familiar with Oracle rules and guidelines for using tables.
|
|
Note:
|
Ways to Open The Table Editor
| Icon | Action | Description |
|---|---|---|
| |
From the Main Menu View Menu | Visual Object Editors | Table Editor |
Open the Table Editor. |
| |
From DB Navigator or Find objects Dialog Right click on a Table object and click Open. |
Open the selected object in the Table Editor. |
User Editor
Use the User Editor to create, grant or revoke roles and privileges to users, including forcing a password to expire.
|
About Oracle Users |
In Oracle, a User is simply a unique log-in name. A user’s capabilities inside the database are determined by the User’s role assignments. The characteristics and usage of this object are described in Oracle documentation. |
Requirements
To edit users:
- You must have the CREATE USER system privilege.
- Query the Oracle Data Dictionary with DBA Views. For more information, see DBA Dictionary Views.
Ways to Open The User Editor
| Icon | Action | Description |
|---|---|---|
| |
From the Main Menu View Menu | Visual Object Editors | User Editor |
Open the User Editor. |
| |
From DB Navigator or Find objects Dialog Right click on a User object and click Open. |
Open the selected object in the User Editor. |
Varray Editor
Use the VArray Type Editor to create varying arrays that can be used to:
- loop through the elements in order
- store only a fixed number of items
- retrieve and manipulate the entire collection as a value.
|
About Varying Array Objects |
The varying array is a collection type you can use when you want to retrieve entire collections as a whole. They are best suited for small collections. If you require a large, efficient collection, you would be better to use a nested table collection type (see Editing a nested table). You must set a maximum number of elements for a varying array but you can change this limit. A varying array object is normally stored in line, that is, in the same tablespace as the other data in its row. The characteristics and usage of this database object are described in Oracle documentation. |