New user needs help with sqlldr

From: <radevenz_at_my-dejanews.com>
Date: Thu, 23 Jul 1998 10:01:30 GMT
Message-ID: <6p71lq$84e$1@nnrp1.dejanews.com>

I am a new user of Oracle and have been tasked to get some raw data stored in text files into a database.

My raw file looks like

AAAABBBCCCDDD            - part identification information
C1 x1                    - part test results (parameter-name and result)
C2 x2                    -   the database has a column for each parameter-name
C3 x3
K4 x4                    - K4 is a parameter-name with no corresponding
C5 x5                    -   column in the database

C6 x6
C9 x9

The database the file has to go into is a quality module import view and looks like this

id1 id2 id3 id4 C1 C2 C3 C4 C5 C6 C7 C8 C9 <- database columns ---- ---- ---- ---- -- -- -- ---- -- -- ---- ---- -- AAAA BBBB CCCC DDDD x1 x2 x3 null x5 x6 null null x9 <- results from file

Any suggestions on how to process my raw data files with sqlldr would be welcome. Please reply to me directly as I do not read this newsgroup regularly.

TIA,
Richard DeVenezia
radevenz_at_ix.netcom.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 23 1998 - 05:01:30 CDT