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.
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.
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.
For more information on object types refer to the official Oracle documentation.