Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Installation Notes

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating