SQLLoader3 (Import when data file does not have a delimiter)

Data file: D:\oracletest\ldr_tab_fiile.dat
1. The middle of the Data File field is tab tab-delimited:
7369SMITHCLERK
7499ALLENSALESMAN
7521WARDSALESMAN
7566JONESMANAGER
= = = Control File:

LOAD'D:\oracletest\ldr_tab_fiile.dat'REPLACE into TABLE   by x'empno,ename'-  - delimited by tab tab ( JOB)

= = = Query result, import successful

SQL>Select* from emp2; EMPNO ename JOB MGR hiredate SAL COMM DEPTNO------------------------------------------------------- ----------------------------7369  SMITH clerk7499  ALLEN salesman  7521  WARD salesman7566 jone Smanager

2. The middle of the data file field is separated by tab tab or space
7369 Smithclerk
7499 Allensalesman
7521 WARD Salesman
7566 Jone Smanager
= = = Control File

LOAD'D:\oracletest\ldr_tab_fiile.dat'REPLACE into TABLE    by whitespace--the end is blank delimited (empno,ename,job)

3, using position to do separate data values
Data files:
7369 CH. Smithclerk
7499 USA. Allensalesman
7521 JP. WARD salesman
7566 HO. Jone Smanager

Control files:

 load   Datainfile   '  

SQLLoader3 (Import when data file does not have a delimiter)