Oracle create table& sql loader

  1.
create   table   mytable  
  (  
      A       NUMBER   not   null,  
      B        VARCHAR2(30)   not null
    ) ;  
注意标点哦
  alter   table   mytable  
      add   constraint   FK_NAME   foreign   key   (B)  
      references   foreignTalbe   (B); 
2.sqlloader: aa.ctl

OPTIONS (skip=1,error=0)
load data
CHARACTERSET UTF8 // for uploading chinese character
infile 'aaaa.csv'
replace // or append
into table mutable
fields terminated by ','
trailing nullcols
(
id,
name,
mark
)

run: sqlldr usrname/password@DBname aa.ctl