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 ?
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 ?