Home » SQL & PL/SQL » SQL & PL/SQL » validation in sql loader (sql*loader)
validation in sql loader [message #282884] Sat, 24 November 2007 11:48 Go to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
I have to cheque if a data is there preveiously in the table while loading data using sql loader.if its a duplicate one it's not desired to be inserted. How to solve this problem?

[Updated on: Sat, 24 November 2007 11:50]

Report message to a moderator

Re: validation in sql loader [message #282887 is a reply to message #282884] Sat, 24 November 2007 12:15 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create unique index on that column; this (duplicate) record will be rejected.
Re: validation in sql loader [message #282900 is a reply to message #282884] Sat, 24 November 2007 22:17 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
actually my problem is i want to insert the new data in another table not the original table.
I mean i am having a table receipt. i have to enter the data in to test receipt from the flat file wich are not in the receipt table.
is there any way to check the validation in control file?
Re: validation in sql loader [message #282901 is a reply to message #282900] Sat, 24 November 2007 22:46 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Your best solution would be to use a Externally Organised Table. It's a bit like SQL*Loader; but instead of pushing the data in from the Operating System, you pull it in from SQL. This gives you all the power of SQL to do whatever you please.

Ross Leishman
Re: validation in sql loader [message #282904 is a reply to message #282901] Sat, 24 November 2007 23:04 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
i am not much familiar with external table. isn't there any soln in sql loader?
Re: validation in sql loader [message #282923 is a reply to message #282904] Sun, 25 November 2007 02:57 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Then GET familiar with it. If you know sqlloader, external tables aren't difficult. They bring a lot of advantages though.
Previous Topic: How to select records depending on date and time values?
Next Topic: Usage of Bulk bind in Select SQL
Goto Forum:
  


Current Time: Sun Dec 11 00:35:59 CST 2016

Total time taken to generate the page: 0.07730 seconds