problem in external table
571157Jun 20 2007 — edited Jun 23 2007Hi
I used external table to import spreadsheet data(csv file) into database...i have values in one column in such a way that it is seperated by comma(,)...like ae123,ae1235 under the column heading 'jobcode'....I want to store the whole data in one column into table..but the data are stored in another column like "ae123" is stored in jobcode column and "ae1235" is stored in another column....can anyone say what is the problem?
my external table definition coding is
CREATE TABLE extsam (
empid varchar2(10),
legcode VARCHAR2(50),
empno VARCHAR2(50),
personname varchar2(100)
)
ORGANIZATION EXTERNAL (
TYPE ORACLE_LOADER
DEFAULT DIRECTORY ext_tables
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
(
empid char(10),
legcode CHAR(50),
empno CHAR(50),
personname char(100)
)
)
LOCATION ('cc.csv')
)
PARALLEL 5
REJECT LIMIT UNLIMITED;
Fazila