Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem in external table

571157Jun 20 2007 — edited Jun 23 2007
Hi
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2007
Added on Jun 20 2007
37 comments
2,264 views