Specify the field definitions for the fields in the imported records:
Attributes are displayed in a grid with four columns (Column Name, Data Type, Data Size/Format, and Null If). This grid allows direct entry of field names, data types, size of the fields, and special characters indicating missing values. If the first record of the file contains field names, the table is populated with names provided in first record. The grid has the following fields:
VARCHAR2(SIZE)
, where SIZE
is defined in Data Size/Format . If you are importing a file that is in multi-record case format, keep in mind that Oracle Data Mining does not display attribute names that are longer than 30 characters. NULL
when the file is loaded. For example if you specify ?
in the Null If for the column named NAME0, every instance of ?
in that column will be translated to NULL
when the file is imported.
If a column has a true null value in the input data, then that value is automatically converted to NULL
during loading. For example, in the row
1,,7
, the second entry will be automatically be converted to NULL
.
To change the datatype of an attribute, click the cell that contains the datatype. Select the new datatype from the dropdown list. For items of type DATE
, see Date Format.
To change the default size for datatype VARCHAR or NUMBER, click the appropriate button.
Note: If you change a value, you must press Enter for the change to take effect.
Click Preview to see the first twenty rows of the new table.
Click Next to continue.
The default format for dates in an Oracle database depends on the NLS_DATE_FORMAT
. For the United Kingdom and the United States of America, the default format is DD-MON-YY
. You can change the default date format using an ALTER SESSION
command. For example, use the following command to change the date format to be a 2-digit month followed by a 2-digit day followed by a 4-digit year:
ALTER SESSION NLS-DATE-FORMAT="MM-DD-YYYY";
After this command executes, "July 4, 2000" will appear as 07-04-2000, instead of the default format 04-JUL-00.
For more information about date formats, see the "Datatypes" chapter in the Oracle Database SQL Reference. See Where to Find More Information to locate this manual.
Copyright © 2006, 2008, Oracle. All rights reserved.