File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Sql Loader Control file Urgent Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Sql Loader Control file Urgent" Watch "Sql Loader Control file Urgent" New topic
Author

Sql Loader Control file Urgent

jothish chokkalingam
Ranch Hand

Joined: Jan 02, 2006
Posts: 57
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


jothish
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

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


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
jothish chokkalingam
Ranch Hand

Joined: Jan 02, 2006
Posts: 57
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

Joined: Feb 05, 2001
Posts: 17250
    
    6

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Sql Loader Control file Urgent