The Data Summarization Viewer displays summary statistics for the selected table or view. Summary statistics for followed by SCHEMA.TABLE
or SCHEMA.VIEW
displays the schema and name of the table or view being summarized. The viewer also displays the Attribute Count for the table or view.
Attributes are summarized in a grid. You can sort the items in the grid by clicking any column header. For all attributes, the grid displays the following:
NUMBER
, FLOAT
, CHAR
, VARCHAR2
, etc.)For attributes with numerical data types such as NUMBER
or FLOAT
, the viewer displays the following additional information:
For attributes with numerical data types, you can change the Mining Attribute Type between categorical and numerical. To do this, select the attribute name and then select the new value from the dropdown menu in the Mining Attribute Type column for the attribute. Note that changing the Mining Attribute Type will result in a different histogram display.
To specify the number of bins for the histogram display of an attribute, select the attribute, and click Preferences. The default is 10 bins. You can change this by typing in a new integer number of bins and clicking OK.
To view the histogram of an attribute, select the attribute and click Histogram.
To close the viewer, select File | Exit from the menu bar.
Copyright © 2005, Oracle. All rights reserved.