| sql loader issue [message #240213] |
Thu, 24 May 2007 06:44  |
|
|
Hello all
I want to load data into two table using a single data file
when i am using .PRN file it is ok..
But when i am using .CSV format it is not working
Plz give suggesion .. the code of Control file is
load data
infile *
into table custom.ram
fields terminated by ',' optionally enclosed by '"'
(ename,dname,sal ,jdate date "DD-Month-YYYY")
into table custom.ramu
(ename,dname)
begindata
Jadu,"D10",45655,09-June-2007
Rahim,"D01",48796,15-September-2006
Thanks
Shakti Goyal
[EDIT reason: message reformatting]
[Updated on: Thu, 24 May 2007 07:08] by Moderator Report message to a moderator |
|
|
|
| Re: sql loader issue [message #240221 is a reply to message #240213] |
Thu, 24 May 2007 07:07  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
You are member of the OraFAQ Forum for several months now and you should know better how to post a question here.
"My car is broken - how can I fix it?" type of questions are out of question. What does it mean "it is not working?" How are we supposed to know if you don't post error message you received?
PRN and CSV files? Where are they? Your example doesn't contain any of those.
Message formatting is poor; I'll remove it.
Finally, why are you posting a SQL*Loader-related question on Forms Forum?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
