| sql loader question [message #333911] |
Mon, 14 July 2008 19:07  |
kowalsky
Messages: 37
Registered: May 2003
|
Member |
|
|
hi everybody,
I am trying to replace some scripts that populate some Oracle 8i tables with some sqlloader jobs. The trick is that the files I am trying to work with are structured as follows:
date: YYYY-MM-DD
header: item1=value, item2=value
header cont: item3=value, item4=value
data:
item5, item6, item7, item8
value, value, value, value
value, value, value, value
whereas the tables contain the item1 thru to item4 and the date as columns (plus the rest item5 thru item8). I know the design is not great (cols 1 to 4 are redundant, plus the date) but this is what I got now.
I can't think of an elegant way to get everything in one pass.
I don't know if I have any parsing ability with sqlldr, I also am restricted to sqlldr since I don't have access to the file system, hence no plsql solution ...
Thanks in advance for any suggestion you may have,
kowalsky
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
