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
1200,'Clark','12-Dec-1980',20
1201,'Alen','1-Jan-1985',30
1202,'Ramanivash','2-Feb-1990',40
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 ","
(Empno,Ename,Hiredate,Deptno)
Thanking you
--
Ma Asalaam
Mohammad Shahnawaz
Passion for Oracle
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
1200,'Clark','12-Dec-1980',20
1201,'Alen','1-Jan-1985',30
1202,'Ramanivash','2-Feb-1990',40
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 ","
(Empno,Ename,Hiredate,Deptno)
Thanking you
--
Ma Asalaam
Mohammad Shahnawaz
Passion for Oracle
No comments:
Post a Comment