to load text file into oracle table
hi
i hv a text file in excel called "emp", i want to load text file into oracle database, thr is no table as such in oralce database called "emp", i want to create and insert records into table called "emp".
1. How to use sql*loader?
2. From where to install sql*loader?
3. Should i use sql*loader through dos prompt?
4. What are the formatting steps while loading text file into oracle database
through sql*loader?
Please can anyone help me to load text file into orale database thorugh sql*loader
with steps.
Regards