Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combining Tables, Deleting Duplicates

Status
Not open for further replies.
skipizza

skipizza

Technical User
Apr 4, 2001
9
0
0
US
I would like to combine three Oracle 8i tables, but when the tables are combined there are duplicate key rows. How can I create a combined table without the duplicate key rows or how can I delete the duplicate key rows?
 
Status
Not open for further replies.

Similar threads

aspiringprog
  • Locked
  • Question
EXTERNAL TABLES IN ORACLE
Replies
1
Views
27
carp
carp
taqmeena
  • Locked
  • Question
Creating SQL8 tables in FORMS DEVELOPER
Replies
1
Views
30
lewisp
lewisp
jayjaybigs
  • Locked
  • Question
Extracting Data from Different tables
Replies
1
Views
12
inkhie
inkhie
fpgiv
  • Locked
  • Question
List of Sequences/Tables
Replies
3
Views
11
lewisp
lewisp
tyb
  • Locked
  • Question
master - details tables
Replies
4
Views
16
HimanB
HimanB

Part and Inventory Search

Sponsor

Back
Top