About Supported Column Types

Columns of all types available in Oracle Database 10g Release (10.2) display as objects in the Design pane. Note the following column restrictions:

• You may only select a maximum of 60 columns for each query.

• The following column types are not selectable and cannot be included in a generated query:

  • BLOB

  • NCLOB

  • RAW

  • LONG

  • LONG RAW

  • XMLType

  • Any other nonscalar column types