how to handle comma (,) in external tables
Currently we are using external tables. The code is like this
create table external_table
(EMPNO NUMBER(4) ,
SAL NUMBER(7, 2),
COMM NUMBER(7, 2),
( type oracle_loader
default directory data_dir
( fields terminated by ',' )
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
no double-quotes wrapping the text? You need to get a new source file.
Click Here to Expand Forum to Full Width