Problem with input ASCII files
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