How to load data from non oracle file to oracle file using Sql Loader. /* Step By Step /*
In this video i am showing you
How We can transfer data from non oracle file to oracle Table.
use Oracle Sql Loader export import datapump utility.
I have data in test file with comma ( , ) separated column. so we can move this data to oracle useing sql loader.
example:
ename, sal, deptno
Joy, 10000, 10
Scott, 2000, 20
Roy, 4000, 30
using this utility must have to create controlfile ( em.ctl
load data infile
append into table scott.test
fields terminated by ','
optionally enclosed by '"'
(ename,sal,deptno)
Create table test with 3 column (ename,sal,deptno)
rum sqlldr command
sqlldr control=/u01/app/parag/em.ctl data=/u01/app/parag/em.txt log=/u01/app/parag/em.log
Login to scott schema and check table
It is very easy to implement.