I just know how to load flat file into oracle database. Oracle has provided us to use both of External Table and SQL Loader. The main functionality for External table is to store data from flat file to oracle database and the SQL Loader is used for load flat file data into External table. Actually for load flat file into oracle we only need SQL Loader, but using External Table is very usefull for operation purpose
Here is a nice tutorial about external table http://www.orafaq.com/node/848
and also about SQL* Loader
Here is a nice tutorial about external table http://www.orafaq.com/node/848
and also about SQL* Loader
1 comment:
It's an awesome piece of writing in support of all the internet users; they will obtain benefit from it I am sure.
Also visit my homepage party pills cheap
Post a Comment