CREATE TABLE TESTING_NEW ( ACCOUNT_DATE DATE, ACCOUNT_NUMBER CHAR (09), ACCOUNT_NUMBER_OLD CHAR (09), ACCOUNT_NAME CHAR (23), ACCOUNT_REGISTRATION CHAR (23), CASH_BALANCE NUMBER (19,2), MONEY_ACCOUNTS NUMBER (12,2), PRICED_INVESTMENTS NUMBER (13,2), MARGIN_BALANCE NUMBER (13,2), MARKET_VALUE NUMBER (13,2) ) ******************************************************** SQL> desc TESTING_NEW Name Null? Type ----------------------------------------- -------- ---------------------------- ACCOUNT_DATE DATE ACCOUNT_NUMBER CHAR(9) ACCOUNT_NUMBER_OLD CHAR(9) ACCOUNT_NAME CHAR(23) ACCOUNT_REGISTRATION CHAR(23) CASH_BALANCE NUMBER(19,2) MONEY_ACCOUNTS NUMBER(12,2) PRICED_INVESTMENTS NUMBER(13,2) MARGIN_BALANCE NUMBER(13,2) MARKET_VALUE NUMBER(13,2) ******************************************************** LOAD DATA INFILE 'H:\TESTING\NEW1.TXT' BADFILE 'TESTING_BAD.TXT' DISCARDFILE 'TESTING_DISCARD.TXT' REPLACE INTO TABLE TESTING_NEW FIELDS TERMINATED BY '?' TRAILING NULLCOLS ( ACCOUNT_DATE date 'MM/DD/YYYY', ACCOUNT_NUMBER CHAR, ACCOUNT_NUMBER_OLD CHAR, ACCOUNT_NAME CHAR, ACCOUNT_REGISTRATION CHAR , CASH_BALANCE NUMBER , MONEY_ACCOUNTS NUMBER , PRICED_INVESTMENTS NUMBER, MARGIN_BALANCE NUMBER, MARKET_VALUE NUMBER ) ******************************************************** ERROR WHEN I TRY TO TO INSERT INTO TESTING_NEW TABLE SQL*Loader-350: Syntax error at line 15. Expecting "," or ")", found "NUMBER". CASH_BALANCE NUMBER , ^