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: 24963
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: 1474
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: Query for Table & Index Growth
Next Topic: SQL performance tuning
Goto Forum:

Current Time: Mon Oct 24 19:20:27 CDT 2016

Total time taken to generate the page: 0.08132 seconds