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
sharri
Messages: 1
Registered: June 2007
Junior Member
Hi,
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
BlackSwan
Messages: 25050
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.
http://www.orafaq.com/forum/t/42427/74940/

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: 1484
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: Sat Dec 10 10:44:26 CST 2016

Total time taken to generate the page: 0.22498 seconds