Saturday, 5 December 2015

Oracle SQL*Loader

As salamo alaikum wa rahmatullah

If you are using oracle database at the same time you need to upload data into oracle table from text file.
Here is sample example how to upload the data from the text file.
For example, you have table named Employee which has columns Empno,Ename,Hiredate,Deptno.
I created a text file name employee.txt here under
now employee text file is ready, after that i have to create a control file.
My control file name is example.ctl and the content is here under
load data
infile 'D:\upload\employee.txt'
into table employee
fileds terminated by ","

Thanking you
Ma Asalaam
Mohammad Shahnawaz
Passion for Oracle

No comments:

Post a Comment