text file into Oracle using Sql?

[dummie2]

I'd like to execute this statement 6000+ times<br>&quot;INSERT INTO table_name VALUES(int,'char',decimal, float)&quot;<br>to get a list of data from a WinZip file into an Oracle table.&nbsp;&nbsp;I don't know where to begin. Can you get me started?

 

[ssingh]

You need to write a Pro*C program where from you need to read text files from C program and&nbsp;&nbsp;fetch it into oracle database with embedded SQL statements.<br><br>Thanx<br>Siddhartha Singh<br><A HREF="mailto:ssingh@aztecsoft.com">ssingh@aztecsoft.com</A>

 

[MikeLacey]

Look at the SQLLDR utility - it does pretty much what you want. It's an Oracle utility designed to bulk load database tables from text files. You define the table and the columns you want to load in a config file - tell it where the data-file is - and away it goes.<br><br>Mike<br> <p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[dummie2]

where is the sqlloader utility?&nbsp;&nbsp;is it on the navigator?

 

[MikeLacey]

SQLLDR comes with Oracle, it will be in your <FONT FACE=monospace><b>$ORACLE_HOME/bin directory</b></font>.<br><br>On unix the name is in lower case <FONT FACE=monospace><b>sqlldr</b></font><br><br>Mike <p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[carp]

You can also find complete directions on how to use this utility in the aptly named Oracle Utility Users Guide.<br>