This week's book giveaway is in the Cloud/Virtualizaton forum.
We're giving away four copies of Mesos in Action and have Roger Ignazio on-line!
See this thread for details.
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Sql Loader Control file Urgent

 
jothish chokkalingam
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i m newbie to sqlloader. i m using this utility for my uploading a file in Data base. i m using a control file for that purpose, for that i my control file is

In the control file i want assign a condition(restrict the number of digits) for numeric values. Can i do it in Control file?


Help me it is urgently needed
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What kind of condition. I remember being able to use CASE statements in control files. However, that was over 3 years ago, so the exact syntax I don't remember. There is always the ability to load the data raw into a holding table and do a query on that table and also use conditionals. But you should be able to do that in the control file.

I know there is a SQLLDR guide online from Oracle on control files and it has everything you can put in them.

Mark
 
jothish chokkalingam
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Mark
i have posted one more thread
http://www.coderanch.com/t/81024/Oracle-OAS/Loading-multiple-tables-delimited-file
can you kindly look in to it and solve the issue in it.
[ September 05, 2006: Message edited by: jothish chokkalingam ]
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Unfortunately, I never had to load two tables from one control file.

But like in my previous response, it might be easier to load it into one table, then create a INSERT INTO b VALUES(SELECT FROM A WHERE something=something)

Other than that I highly suggest finding that Oracle manual on SQLLDR.

Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic