Chatta subito con l'assistenza
Chat con il supporto

SQL Navigator for Oracle 7.6 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

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:

  • tables
  • views
  • other synonyms
  • functions
  • packages
  • procedures
  • sequences
  • database links

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:

  • Be sure to place quote marks ("xxx") around any non-numerical data you enter in the default column. If non-numerical data is not enclosed in quotes, then error message ‘ORA-00984: column not allowed here’ is returned.
  • It is possible to display and edit multi byte data in the Table Editor through National Language Support (NLS).
  • The Data tab operates as per the SQL Query Results Data Grid.

 

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:

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.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione