Im trying to create a externla table for comma delimited file
but it also has a scenario where Fields can have a Comma enclosed in "" for example
sample Record
1,one,first
2,two,second
3,three,third
4,four,"4,fourth"
Sample table
create table ext_table_csv (
i Number,
n Varchar2(20),
m Varchar2(20)
)
organization external (
type oracle_loader
default directory ext_dir
access parameters (
records delimited by newline
fields terminated by ','
missing field values are null
)
location ('file.csv')
)
reject limit unlimited;
So when i query this Externla table 4th record will be read as
O/p
i n m
4 four "4
{code}
Above Ext table is just an example, Im adding bad file and log file in real table.
Please help me if there is a way this can be resolved with external table.