Home » RDBMS Server » Server Utilities » problem in loading data into table (10gR2 Linux)
problem in loading data into table [message #519724] Tue, 16 August 2011 09:01 Go to previous message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
Hi all,
i have a table revenue
create table revenue
(
person varchar2(23),
month  varchar2(3),
rev_amt number
)


and i have data in a file like below
Person   Jan Feb Mar Apr Mai Jun Jul Aug Sep Oct Nov Dez
--------------------------------------------------------
Schnyder,345,223,122,345,324,244,123,123,345,121,345,197
   Weber,234,234,123,457,456,287,234,123,678,656,341,567
  Keller,596,276,347,134,743,545,216,456,124,753,346,456
   Meyer,987,345,645,567,834,567,789,234,678,973,456,125
  Holzer,509,154,876,347,146,788,174,986,568,246,324,987
  Müller,456,125,678,235,878,237,567,237,788,237,324,778
Binggeli,487,347,458,347,235,864,689,235,764,964,624,347
 Stoller,596,237,976,876,346,567,126,879,125,568,124,753
   Marty,094,234,235,763,054,567,237,457,325,753,577,346
  Studer,784,567,235,753,124,575,864,235,753,864,634,678


i want to load it into the table in the following way.
Person    Month   Revenue
-------------------------
Schnyder    Jan       345
Schnyder    Feb       223
Schnyder    Mar       122
Schnyder    Apr       345
Schnyder    Mai       324
Schnyder    Jun       244
Schnyder    Jul       123
Schnyder    Aug       123
Schnyder    Sep       345
Schnyder    Oct       121
Schnyder    Nov       345
Schnyder    Dez       197
........    ...       ...

Please tell me how to write control file to load this data into the above revenue table.
Thanks in Advance.
 
Read Message
Read Message
Read Message
Previous Topic: Data Pump and resumable_timeout
Next Topic: Problem Loading Data into Table- Tow fields appended & Converted into DateTime
Goto Forum:
  


Current Time: Thu Apr 25 22:24:31 CDT 2024