| loading selective data [message #164438] |
Thu, 23 March 2006 08:12  |
mnaveed
Messages: 2
Registered: March 2006
|
Junior Member |
|
|
HI everyone
i am new to sql loader can some one help me with example that how to load selective data from text file into a table my data file is some how like this.
--------------*************start******************-------------------
123 rec_num 12345
1 abc
1 fgh date 15/12/06
1 cdf
1 lmn act 001 00010110
2 ppp 1
2 qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
456 trtrtr t(0000)
1 ------------------------------------------------------
2 rwrwer
1 hhfhfh
1 gdgdgsd
098 gdfgdffg
2 sdgsgdg
2 gdgdgdg 0.00
123 rec_num 12346
------------------************END****************--------------
and file goes on like this with diff sections based on marker like "123" or "098" one file got one marker multiple times on different location within a file .i want to read data with in each section and want to put it in tables based on rec_num.like from one rec_num to other rec_num
any solution will be very help full
thanks in advance
|
|
|
|
|
|
| Re: loading selective data [message #164457 is a reply to message #164454] |
Thu, 23 March 2006 09:19  |
mnaveed
Messages: 2
Registered: March 2006
|
Junior Member |
|
|
marker always have position(1:3) and rows under marker always start with number 1 or 2 which is at position (4) file format is like this ignore(.) char
123 rec_num 12345
...1 aaaaa
...1 aaaaa date 12/02/03
.
.
.
098 kkkkkk
...1 mmmmmm
...1
.
.
.
123 rec_num 12346
and so on
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
