The most common way is to use the Oracle client's SQL loader application, the name of which escapes me at the moment. Oracle's online documentation will have information about this. It might be called sqlloader or something like that.
Another way is to write your own script. Just write a Java program that parses your text file and turns each set of data into an insert or update statement. This will give you some good JDBC practice anyway. Erik -----Original Message----- >From: "Jonnalagadda, Sumithra" <[EMAIL PROTECTED]> >Sent: Feb 6, 2006 12:58 PM >To: 'Struts Users Mailing List' <user@struts.apache.org> >Subject: [OT]Loading data into oracle database table from a txt file. > >I have data in a text file with a delimiter. How will I import this data >into a table in orcale database? > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
