-
how to handle comma (,) in external tables
Hi All
Currently we are using external tables. The code is like this
create table external_table
(EMPNO NUMBER(4) ,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7, 2),
COMM NUMBER(7, 2),
DEPTNO NUMBER(2)
)
ORGANIZATION EXTERNAL
( type oracle_loader
default directory data_dir
access parameters
( fields terminated by ',' )
location ('emp.dat')
)
So this will take a comma as a field terminator. But in some rare cases i am also getting teh data with commas causing the initial load to fail.
How do i take care of such a scenario
bye
-
no double-quotes wrapping the text? You need to get a new source file.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|