Home > database >  SQLLDR error SQL * Loader - 350: a syntax error in line 4.
SQLLDR error SQL * Loader - 350: a syntax error in line 4.

Time:10-04

Reoccupy SQLLDR derivative according to encounter this error:
SQL * Loader - 350: a syntax error in line 4,
Expected value is "(", and the actual value is" field ",
The field terminated by a '^'

This is the control file content
The load data
BADFILE 'input. Bad'
Append into table table1
The field terminated by a '^'
(name, grade, sex)

CodePudding user response:

The load data
Infile 'ta_carin2011. TXT'
Append
Into the table ta_carin
Fields terminated by X '09'
The TRAILING NULLCOLS
(RECORD_NO,

CodePudding user response:

fields
  • Related