OraFAQ Forum: SQL & PL/SQL » Load .csv file with dynamic content into oracle tables

Home » SQL & PL/SQL » SQL & PL/SQL » Load .csv file with dynamic content into oracle tables (oracle11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Load .csv file with dynamic content into oracle tables [message #607406]

Wed, 05 February 2014 13:13

oracledomain
Messages: 1
Registered: February 2014

Junior Member

Hi Friends,

I have list of .csv files (2100 fields) which has dynamic values within it and corresponding header files also. I need to load the data from this file into oracle table. Please help to design this.

Report message to a moderator

Re: Load .csv file with dynamic content into oracle tables [message #607407 is a reply to message #607406]

Wed, 05 February 2014 13:20

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Too few information to help.
Read about SQL*Loader and external table.

Report message to a moderator

Re: Load .csv file with dynamic content into oracle tables [message #607408 is a reply to message #607407]

Wed, 05 February 2014 13:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I have list of .csv files (2100 fields) which has dynamic values within it
How can static text file contain "dynamic values"?

A table is limited to 1000 columns.

post CREATE TABLE statement for the table into which this data is to be loaded.

Report message to a moderator

Previous Topic:	repeating items in a string
Next Topic:	Sql Loop

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 09:55:57 CDT 2024