Home » SQL & PL/SQL » SQL & PL/SQL » Inserting unique records
Inserting unique records [message #243759] Fri, 08 June 2007 15:50 Go to next message
Messages: 1
Registered: June 2007
Junior Member
I am trying to take data from a flat file and insert it into a table.
I want to insert unique records not duplicates.
Anyone have any suggestions?
Re: Inserting unique records [message #243760 is a reply to message #243759] Fri, 08 June 2007 15:55 Go to previous messageGo to next message
Messages: 25570
Registered: January 2009
Location: SoCal
Senior Member
>Anyone have any suggestions?
Please read and FOLLOW the posting guidelines as stated in the #1 STICKY post at the top of this forum.

Go research "external table".
Re: Inserting unique records [message #243824 is a reply to message #243759] Sat, 09 June 2007 07:32 Go to previous message
Bill B
Messages: 1662
Registered: December 2004
Senior Member
set it up as an external table and use group by or distinct on the select when you insert into the real table.

[Updated on: Sat, 09 June 2007 07:33]

Report message to a moderator

Previous Topic: performance tuning of merge
Next Topic: SQL performance tuning
Goto Forum:

Current Time: Sat Aug 19 04:31:52 CDT 2017

Total time taken to generate the page: 0.04873 seconds