The problem is when I put more than two double quote in the NAME column (check below code) then sqlldr fails.
In **data.txt** file, first 3 records are failing because the NAME column (2nd position in the record) has more than 2 double quotes.
Please assist. I think some function I need to put in control file against NAME column.

**You can run the below code and check, first 3 records will fail and the last record will get inserted, I want to insert all records with or without double quote:**

```
--table creation
    create table employee
    (      
      name varchar2(4000)      
    );

--control file
load data
 infile '/tmp/swetabh/data.txt' 
 into table employee
 truncate
 fields terminated by "," OPTIONALLY ENCLOSED by '"'  TRAILING NULLCOLS 
 (
 name      
 )

--data.txt (SEE ALL RECORDS ARE HAVING MORE THAN 2 DOUBLE QUOTE AND WANT TO INSERT DATA TO THE TABLE WITH OR WITHOUT DOUBLE QUOTE)
""start with double quote       "
"end with double quote          ""
"double quote " in the middle   "

```

-bash-4.1$ sqlldr userid=xxx/xxx@xxxx control=/tmp/swetabh/control.txt log=/tmp/swetabh/control.log bad=/tmp/swetabh/bad.txt readsize=2000000000 bindsize=2000000000