java - 如何在 sqlldr ctl 文件中设置主键？

Question

我这里有下面的文件

load data
infile 'emp.csv'
into table EMPLOYEES
append
fields terminated by ',' 
optionally ENCLOSED BY '"'
TRAILING NULLCOLS
(
TENANTID,
EMPLOYEEID,
ISEMPLOYEEACTIVE,
PASSWORD,
EMPLOYEEMANAGERID,
FIRSTNAME,
LASTNAME,
MIDDLENAME,
EMPLOYEEEMAILID,
EMPLOYEEASSISTANTID ,
CATEGORYID,
EMPLOYEENATIONALITY,
BRANCHID ,
GRADEID ,
PASSWORDRESETTOKEN,
PASSWORDRESETCREATEDATE,
ISBRANCHHEAD ,
DEFAULTCOSTCODE ,
GENDER 
)

在此文件中 EMPLOYEEID 是主键，因此如何将该列设置为主键...因为每次都需要唯一且自动生成的编号

这是我的 emp.csv 文件

1006,1,0,saasas,1049,LoadData,lol,lol,bhargav121@gmail.com,1049,1125,India,2192,1128,1,1,1,1051,m

Answer 1

在数据库中。创建序列 EMPLOYEES_SEQ

在ctl文件中

...
TENANTID,
EMPLOYEEID "EMPLOYEES_SEQ.NEXTVAL",
ISEMPLOYEEACTIVE,
...