title: Export oracle table data as sql Insert-String
body: <p>this is me Francisco that wrote the first question  <a href="https://stackoverflow.com/questions/2118298/oracle-tables-data-to-insert-statements-with-java">click-here</a> , but now I've an account. I'll try to explain it. For a Job I need a .txt file that contains the SQl string inserts from an Oracle Table. I can't use a Software like toad because I need to do it with Java Code. I'm not trying to get the inserts's logging , I need a to export it from a table. The Client ask for it, this is the crucial thing.You say the normal way to do it is using DataPump utility, but using this tools, will I get a text file? I read that DataPump works with binaries files. using Java JDBC and metadata, I need to convert all in String file, ok for it I'm agree, but I have to write a lot of code to know what kind of type I get from the Table to parse it. One example is with Date types, oracle softwares parse it as to_date('0005-11-21','DD/MM/RR') and java toTostrig will do it something like '2009-1-25 13:00:00'. Java toString method will truncate some Number types So I need to know if someone did it or can help me.</p>
  
  <p>I'm a newby for this page, could anyone edit the first question or how can I update it if I did it with a non registered user?</p>
  
  <p>Thank you very much. Francisco</p>