db and dev 10g rel2
hi all ,
i've posted a question before asking about how to import the very new record of a .csv file into oracle database ,
but now , my question is changed , i think to easier .
now i want to import the whole file into a table in my database by clicking a button on my form ?
what is the way for doing so ?
thanks in advance
Use TEXT_IO or CLIENT_TEXT_IO to read the file. For each line in the file, cut it into pieces using SUBSTR, then issue an insert into your table.
Search the forum, there are lots of examples on TEXT_IO.
thanks andreas , i am trying to do so , but the problem is
substr is used like so :
substr(12345678,0,3) , so the result is '123' , but in this example i know the number in front of me , i know that it comprises of 8 digits , but
in the csv file , the situation is different , the lines are saved like so :
and there is a comma between all words(fields) , then how to cut only the first field to the first "," , then the second field to the second "," and so on ?