Question QUESTION: Hello Ma'am,
I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table.
Can you guide me how to do this???
ANSWER: Hi Shalabh,
You can do this by using sql loader. Please find detailed info at the following site -
QUESTION: Thank you ma'am for the suggestion but I have to write my own code that parses the CSV file and generate INSERT statements to load into the Oracle database.
can you help???
Answer Hi Shalabh,
I am not understanding exactly what you want. If you want to create an sql file with insert statements (without validating data) for all these rows, you can do it through vi editor in unix. If this is what you require, please let me know so that I can help further.
If you want to read and parse the CSV file using PL/SQL, please send me in detail how you want the program to execute.
