Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
Hi,
Maybe someone can give me advice , I am relatively new to Oracle and I need to load data from a text file into a database table. The format of the file and DB table is below so I would need an example script which would load the data.Thanks in advance
=========================
smith:1044:233:2006-04-01
jones:1045:122:2005-02-04
Ford:1045:132:2006-04-23========================
Table - Emp
Name
emp_no
dept_no
date

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_concepts.htm#sthref478
Example 6-1 Loading Data in Fixed Record Format
load data
infile 'example.dat' "fix 11"
into table example
fields terminated by ',' optionally enclosed by '"'
(col1, col2)example.dat:
001, cd, 0002,fghi,
00003,lmn,
1, "pqrs",
0005,uvwx,
Luke Chi

![]() |
![]() |
![]() |

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |