home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!darwin.sura.net!jvnc.net!netnews.upenn.edu!uofs!jaguar.uofs.edu!littlec1
- From: littlec1@jaguar.uofs.edu (Chris Little)
- Newsgroups: comp.databases.oracle
- Subject: Re: Deleting Duplicates
- Message-ID: <1992Jul23.091611.1@jaguar.uofs.edu>
- Date: 23 Jul 92 14:16:11 GMT
- References: <VN70NB1w165w@iowegia.uucp>
- Sender: news@uofs.uofs.edu
- Organization: University of Scranton
- Lines: 16
- Nntp-Posting-Host: jaguar.ucs.uofs.edu
-
- In article <VN70NB1w165w@iowegia.uucp>, bob@iowegia.uucp (Bob Powers) writes:
- > How can I delete duplicate rows in a table using SQL*PLUS. This is
- > an unindexed table and I would like to keep it that way.
-
- I'm relatively new at the job, but I suspect you could create a similar
- table, do an INSERT SELECT UNIQUE from the old table to the new table,
- delete all rows from the old table, copy all rows from the new table
- to the old, and then drop the new one. Maybe there's a better way.
-
- Good Luck.
-
- --
- Chris Little, Programmer/DBA
- University Computing Systems
- University of Scranton
- LITTLEC1@JAGUAR.UOFS.EDU Scranton, PA 18510
-