Problem with input ASCII files

From: Thib <Philippart_at_geru.ucl.ac.be>
Date: 1998/03/30
Message-ID: <351F76AE.E4ECC146_at_geru.ucl.ac.be>#1/1


    Hello,

    I'm a new user of Oracle 8 and I have a question.

    I would like to extract some informations from ASCII files and put them into tables. The files have 2 components: on the top, there is an header and beneath the header we find columns of data. To read these data's, I'm using SQL*Loader and it work properly.

    But I've a big problem with the header ! I would like to read some informations from it to put them in another table and I wonder how I can do this. Here is an example:

Top of ASCII file
\ |
\ file created by: CREATOR | header
\ date of creation: 22/03/98 |

\...                                               |
column_1 column_2
    1                 45                        |
    2                78                         |   data's
    3                86                         |
...
End of file

    For example, the aim is to read CREATOR and put this word in another column, called column_3
 With SQL*Loader, I can only read columns of data.

    How can I do ? HELP !!! Can I use others tools ? I saw a package provided with Oracle 8, and called UTL_FILE. Unfortunately, I don't understand the syntax of the "FOPEN" function and I'm not sure that it can help me.

    Please, can you help me ?
    Regards,

Thibaut Received on Mon Mar 30 1998 - 00:00:00 CEST

Original text of this message