Re: urgent

From: Nikunj Gupta <good_dba_at_hotmail.com>
Date: Thu, 19 Oct 2000 00:35:41 -0700
Message-Id: <10654.119744@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_00E1_01C03964.82DCDFC0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

urgentHi Swapna,

Use ROWID... (if you are not willing to use where clause with a long = list of values)

Thanks

Nikunj

Original Message -----=20 From: Swapna_P=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, October 18, 2000 01:06 PM Subject: urgent

how to delete the duplicate records from a table............=20 except for one field all the rest of the fields are the same,so want = to eliminate one record=20

TIA=20
swapna=20

------=_NextPart_000_00E1_01C03964.82DCDFC0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>urgent</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Swapna,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Use ROWID... (if you are not willing to =
use where=20
clause with a long list of values)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Nikunj</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A title=3DSwapna_P_at_satyam.com =
href=3D"mailto:Swapna_P_at_satyam.com">Swapna_P</A>=20   </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, October 18, = 2000 01:06=20
  PM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> urgent</DIV>
  <DIV><BR></DIV>
  <P><FONT face=3DArial color=3D#800080>how to delete the duplicate =

records from a=20
table............</FONT> <BR><FONT face=3DArial color=3D#800080>except = for one=20
field all the rest of the fields are the same,so want to eliminate one =

  record</FONT> </P>
  <P><FONT face=3DArial color=3D#800080>TIA</FONT> <BR><FONT = face=3DArial=20
  color=3D#800080>swapna</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Thu Oct 19 2000 - 02:35:41 CDT