<< Click to Display Table of Contents >>

Overview Types

Top Previous Next

Overview Types is the default sheet. It presents a list of all PL/SQL types owned by the current schema:

Type name


Time stamps of creation and last DDL time


Below the grid is another set of tabs that lets you switch between

Collection Types

Object Types

Object Type Bodies

Incomplete Types (where Oracle cannot specify the kind of type because of a syntax error.)

Invalid objects are grayed. Objects with errors are shown in red.


The following context operations are available:



Creates a new type.



Drops a type.


Show DLL

Generates DDL for the selected object to a file


Grid View

For more information, see object window