How can you load fixed length records using SQL*Loader? | Oracle DBA

You can use the following code snippet to load the fixed length records:
load data
infile 'c:\data\mydata.txt'
replace
into table departments
( dept position (02:05) chat(4),
deptname position (08:27) char(20))
The mydata.txt file appers as follows:
begindata
COSC COMPUTER SCIENCE
ENGL ENGLISH LITERATURE
MATH MATHAMATICS
POLY POLITICAL SCIENCE