Online Documentation for SQL Manager for Oracle

Creating/editing object type


Use the Object Type tab of Object Type Editor to create/edit the specification of an object type, a SQLJ object type, or an incomplete object type.

 

Name

Specify the name of the object type to be created, or view the name of the object type being edited. Note that the object type name must be unique within its schema.

 

Schema

Use the drop-down list to specify the schema in which the object type will be created.

 

The lower area of the editor window allows you to specify the object type definition. The variables that form the data structure are called attributes. The member subprograms that define the behavior of the object are called methods. The keywords AS OBJECT are required when creating an object type. The DDL tab will display the changes made to the object type definition.

 

For your convenience the code folding, syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with Query Data area and Using the context menu.

 

Object Type Editor - Editing Object Type definition

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.

 

For more information on object types refer to the official Oracle documentation.