Question: how to import data from flat file to oracle database?
Answer: SQLLOADER. sqlloader is an Oracle utility to load data from external files to table. ... 
EXTERNAL TABLES. External tables is an advanced feature of Oracle SQLLOADER. ... 
UTL. UTL is another Oracle utility to load data from flat file to Oracle and vice versa. ... 
Using Tools (SQLDEVELOPER) EMP. ... 
INSERT script.