Re: import csv/txt to database
Hi khan,
We can use the delimieter # . you can use this delimieter and import into the file.
i will provide a sample text content of my txt file and import the content in my table it works . try this and update to us.
#ri,#4#
#gn#,#30#
load data infile '/tmp/person.txt' into table person fields enclosed by "#" terminated by "," lines terminated by '\n' (po1,ag1);
Subject
Written By
Posted
Re: import csv/txt to database
January 05, 2012 11:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.