OT/HUMOR RE: ORDER BY ..

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Tue, 7 Nov 2000 13:29:54 -0500
Message-Id: <10673.121333@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C048E9.0B7119D0
Content-Type: text/plain;

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

Hell, Jared, why not move Lee to Texas, and just fry 'em?

That'll teach 'em a lesson, Amerikkkan-style!

Yours in Excessive Scolding and Punishment,=20

etc...

-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca] Sent: Tuesday, November 07, 2000 12:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORDER BY ..

Jared,

Could you bump Lee off the list, there is no need to reply in this = manner,
especially when the other person's first language is obviously not = English.

Vera,

ORDER BY is a clause, not a transaction, but I know what you were = trying to
get across.

Unfortunately it's not that simple, there are a lot of factors that = make
queries (and transactions) run slowly. It depends on hardware, on some initialization parameters, on whether indexes exist on the tables you = are
querying, and on the order in which items are placed in your query. = That's
not the end of it, though, there are many other factors to consider. = It
takes months if not years to get to a point that you can feel confident about writing good SQL and PL/SQL code, and knowing how to configure = Oracle
database servers properly.

In many cases, however, queries run poorly because of the way they are written. Perhaps you could send me a copy of your query (not through = the
listserv given the reaction you got from Lee) and maybe I can point out = a
few things you can try to improve your query's performance.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	lerobe - Lee Robertson [SMTP:LEROBE_at_acxiom.co.uk]
	Sent:	Tuesday, November 07, 2000 12:36 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	RE: ORDER BY ..

	GO ON - I DARE ONE OF YOU !!!!!



	-----Original Message-----
	[mailto:Marcos.Vera_at_msconsultores.com.pe]
	Sent: 07 November 2000 15:26
	To: Multiple recipients of list ORACLE-L





	i want my 'order by' transaction to be quick...very quick ...
	what oracle parameter should i increase or decrease ???

	Thanks a lot .








	"bunyamin karadeniz" <bunyamink_at_havelsan.com.tr> on 07/11/2000

02:55:22 AM

	Please respond to ORACLE-L_at_fatcity.com
	=20

	=20

	=20





	                                                             =20

	                                                             =20

	                                                             =20

	 To:      Multiple recipients of list ORACLE-L               =20
	          <ORACLE-L_at_fatcity.com>                             =20


	                                                             =20

	 cc:      (bcc: Marcos Vera/M&S Consultores/51)              =20


	                                                             =20

	                                                             =20

	                                                             =20

	 Subject: Re: Query to select only the duplicate records from=20
	          a table?                                           =20


	                                                             =20








	SELECT interested_columns
	FROM table_name a
	WHERE rowid >(SELECT min(rowid)
	FROM table_name b
	WHERE b.pk_column =3D a.pk_column ) ;

	*pk_coloumn is the primary key column the table.
	if you want to delete the duplicate rows, just change the select to

DELETE

if you want to leave only one row of the duplicated rows,For ex: you have 3 duplicated rows and want to delete 2 of them and leave only one, The only possibility as I understand is first selecting the duplicate rows with DISTINCT and then insert into another table and then delete duplicated rows from the base table and select from second table and insert into base table.******

	Bunyamin K. Karadeniz
	Enformasyon Teknolojileri Dir.
	Veri Tabani Grubu tel : 2873565/1681
	HAVELSAN
	**********************************************

	> -----Original Message-----
	> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
	> Date: Monday, November 06, 2000 2:38 PM
	>
	>
	> >Hello Lists,
	> >
	> >Can any body help me in writing a query which will
	> >list only the duplicate records from a table?
	> >
	> >Any help would be highly appreciated.
	> >
	> >TIA,
	> >Muru
	> >
	> >__________________________________________________
	> >Do You Yahoo!?
	> >Thousands of Stores.  Millions of Products.  All in one Place.
	> >http://shopping.yahoo.com/
	> >--
	> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
	> >--
	> >Author: Murugesan Balakrishnan
	> >  INET: mail_oracle_at_yahoo.com
	> >
	> >Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
	> >San Diego, California        -- Public Internet access / Mailing
Lists
	>
>--------------------------------------------------------------------
	> >To REMOVE yourself from this mailing list, send an E-Mail message
	> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
in
	> >the message BODY, include a line containing: UNSUB ORACLE-L
	> >(or the name of mailing list you want to be removed from).  You
may
	> >also send the HELP command for other information (like
subscribing).
	>
	> --
	> Please see the official ORACLE-L FAQ: http://www.orafaq.com
	> --
	> Author: Jim Walski
	>   INET: jwalski3_at_classicplan.com
	>
	> Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
	> San Diego, California        -- Public Internet access / Mailing
Lists
	>
--------------------------------------------------------------------
	> To REMOVE yourself from this mailing list, send an E-Mail message
	> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
in
	> the message BODY, include a line containing: UNSUB ORACLE-L
	> (or the name of mailing list you want to be removed from).  You
may
	> also send the HELP command for other information (like

subscribing).

	--
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
	--
	Author: bunyamin karadeniz
	  INET: bunyamink_at_havelsan.com.tr

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may
	also send the HELP command for other information (like subscribing).



	--=20
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
	--=20
	Author:=20
	  INET: Marcos.Vera_at_msconsultores.com.pe

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may
	also send the HELP command for other information (like subscribing).


	The information contained in this communication is
	confidential, is intended only for the use of the recipient
	named above, and may be legally privileged. If the reader=20
	of this message is not the intended recipient, you are
	hereby notified that any dissemination, distribution or
	copying of this communication is strictly prohibited. =20
	If you have received this communication in error, please=20
	re-send this communication to the sender and delete the=20
	original message or any copy of it from your computer
	system.
	--=20
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
	--=20
	Author: lerobe - Lee Robertson
	  INET: LEROBE_at_acxiom.co.uk

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may
	also send the HELP command for other information (like subscribing).

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C048E9.0B7119D0
Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>OT/HUMOR RE: ORDER BY ..</TITLE>
</HEAD>
<BODY>

Hell, Jared, why not move Lee to Texas, and just fry = 'em?

That'll teach 'em a lesson, Amerikkkan-style!

Yours in Excessive Scolding and Punishment,

etc...

-----Original Message----- From: Boivin, Patrice J [<A = HREF=3D"mailto:BoivinP_at_mar.dfo-mpo.gc.ca">mailto:BoivinP_at_mar.dfo-mpo.gc.= ca</A>]

<BR><FONT SIZE=3D2>Sent: Tuesday, November 07, 2000 12:56 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: ORDER BY ..</FONT>
</P>
<BR>

Jared,

Could you bump Lee off the list, there is no need to = reply in this manner,
 especially when the other person's first language is = obviously not English.

Vera,

ORDER BY is a clause, not a transaction, but I know = what you were trying to
 get across.

Unfortunately it's not that simple, there are a lot = of factors that make
 queries (and transactions) run slowly.  It = depends on hardware, on some
 initialization parameters, on whether indexes exist = on the tables you are
 querying, and on the order in which items are placed = in your query.  That's
 not the end of it, though, there are many other = factors to consider.  It
 takes months if not years to get to a point that you = can feel confident
 about writing good SQL and PL/SQL code, and knowing = how to configure Oracle
 database servers properly.

In many cases, however, queries run poorly because of = the way they are
 written.  Perhaps you could send me a copy of = your query (not through the
 listserv given the reaction you got from Lee) and = maybe I can point out a
 few things you can try to improve your query's = performance.

<P><FONT SIZE=3D2>Regards,</FONT>
<BR><FONT SIZE=3D2>Patrice Boivin</FONT>
<BR><FONT SIZE=3D2>Systems Analyst (Oracle Certified DBA)</FONT>
</P>

Systems Admin & Operations | Admin. et Exploit. = des syst=E8mes
 Technology =
Services        | Services = technologiques
 Informatics =
Branch         | Direction de = l'informatique 
 Maritimes Region, DFO      = | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <<A = HREF=3D"mailto:boivinp_at_mar.dfo-mpo.gc.ca">mailto:boivinp_at_mar.dfo-mpo.gc.= ca</A>>

-----Original Message-----         From:   lerobe - Lee Robertson = [SMTP:LEROBE_at_acxiom.co.uk]
         Sent:   Tuesday, November 07, 2000 12:36 PM         To:     Multiple recipients of list = ORACLE-L
         Subject:        RE: ORDER = BY ..

GO ON - I = DARE ONE OF YOU !!!!!

</P>
<BR>
<BR>

-----Original Message-----         [<A = HREF=3D"mailto:Marcos.Vera_at_msconsultores.com.pe">mailto:Marcos.Vera_at_msco= nsultores.com.pe</A>]
         Sent: 07 = November 2000 15:26
         To: = Multiple recipients of list ORACLE-L

</P>
<BR>
<BR>
<BR>
<BR>

i want my = 'order by' transaction to be quick...very quick ...         what = oracle parameter should i increase or decrease ???

Thanks a = lot .

</P>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>

"bunyamin karadeniz" = <bunyamink_at_havelsan.com.tr> on 07/11/2000 02:55:22 AM

Please = respond to ORACLE-L_at_fatcity.com

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2> =
</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2> =

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2> =
</FONT>
</P>
<BR>
<BR>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=

sp;           &nb= sp;   
         <FONT =

SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; </FONT>

<FONT =

SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; </FONT>

= To:      Multiple recipients of list = ORACLE-L          &nbs= p;     
                   =

&lt;ORACLE-L_at_fatcity.com&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<FONT =

SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; </FONT>

=

cc:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (bcc: Marcos Vera/M&amp;S =
Consultores/51)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<FONT =

SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; </FONT>

<FONT =

SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; </FONT>

<FONT =

SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; </FONT>

= Subject: Re: Query to select only the duplicate records from                   a =

table?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<FONT =

SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; </FONT>
</P>
<BR>
<BR>
<BR>
<BR>

SELECT = interested_columns
         FROM = table_name a

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>WHERE =
rowid &gt;(SELECT min(rowid)</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>FROM =

table_name b
         WHERE = b.pk_column =3D a.pk_column ) ;

*pk_coloumn is the primary key column the table.         if you = want to delete the duplicate rows, just change the select to DELETE

****** if = you want to leave only one row of the duplicated rows,For ex: you
         have 3 = duplicated rows and want to delete 2 of them and leave only one, The
         only = possibility as I understand is first selecting the duplicate rows with
         DISTINCT  and then insert into another table and then = delete
 duplicated rows         from the = base table and select from second table and insert into base
         table.******

<FONT =

SIZE=3D2>**********************************************</FONT>

Bunyamin = K. Karadeniz
         Enformasyon Teknolojileri Dir.         Veri = Tabani Grubu tel : 2873565/1681
         HAVELSAN
         <FONT =

SIZE=3D2>**********************************************</FONT>

> = -----Original Message-----
         > To: = Multiple recipients of list ORACLE-L =
<ORACLE-L_at_fatcity.com>
         > = Date: Monday, November 06, 2000 2:38 PM         >
         >
         > = >Hello Lists,
         > = >
         > = >Can any body help me in writing a query which will         > = >list only the duplicate records from a table?         > = >
         > = >Any help would be highly appreciated.         > = >
         > = >TIA,
         > = >Muru
         > = >
         > =

&gt;__________________________________________________</FONT>

> = >Do You Yahoo!?
         > = >Thousands of Stores.  Millions of Products.  All in one = Place.
         > = ><A HREF=3D"http://shopping.yahoo.com/" = TARGET=3D"_blank">http://shopping.yahoo.com/</A>         > = >--
         > = >Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>         > = >--
         > = >Author: Murugesan Balakrishnan

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>&gt; =
&gt;&nbsp; INET: mail_oracle_at_yahoo.com</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>&gt; =

>
         > = >Fat City Network Services    -- (858) 538-5051  = FAX: (858)
 538-5051
         > = >San Diego, California        -- = Public Internet access / Mailing
 Lists
         >
 <FONT =

SIZE=3D2>&gt;-----------------------------------------------------------=

---------
         > = >To REMOVE yourself from this mailing list, send an E-Mail = message
         > = >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') = and
 in
         > = >the message BODY, include a line containing: UNSUB ORACLE-L         > = >(or the name of mailing list you want to be removed from).  = You
 may
         > = >also send the HELP command for other information (like subscribing).
         >
         > = --
         > = Please see the official ORACLE-L FAQ: <A HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A>         > = --
         > = Author: Jim Walski
         >   INET: jwalski3_at_classicplan.com         >
         > Fat = City Network Services    -- (858) 538-5051  FAX: = (858)
 538-5051
         > San = Diego, California        -- Public = Internet access / Mailing
 Lists
         >
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
         > To = REMOVE yourself from this mailing list, send an E-Mail message         > to: = ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>&gt; the =
message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>&gt; (or =

the name of mailing list you want to be removed from).  You may
         > also = send the HELP command for other information (like subscribing).

--         Please = see the official ORACLE-L FAQ: <A HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A>         --         Author: = bunyamin karadeniz
           = INET: bunyamink_at_havelsan.com.tr

Fat City = Network Services    -- (858) 538-5051  FAX: (858) = 538-5051
         San = Diego, California        -- Public = Internet access / Mailing
 Lists
         <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>To REMOVE =
yourself from this mailing list, send an E-Mail message</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>to: =

ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>the =
message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>(or the =

name of mailing list you want to be removed from).  You may         also send = the HELP command for other information (like subscribing).

</P>
<BR>
<BR>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>-- =
</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>Author: =
</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>&nbsp; =

INET: Marcos.Vera_at_msconsultores.com.pe

SIZE=3D2>---------------------------------------------------------------=

-----

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>To REMOVE =
yourself from this mailing list, send an E-Mail message</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>to: =

ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>the =
message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>(or the =

name of mailing list you want to be removed from).  You may         also send = the HELP command for other information (like subscribing).

The = information contained in this communication is         confidential, is intended only for the use of the = recipient
         named = above, and may be legally privileged. If the reader         of this = message is not the intended recipient, you are         hereby = notified that any dissemination, distribution or         copying = of this communication is strictly prohibited.          If you = have received this communication in error, please         re-send = this communication to the sender and delete the         original = message or any copy of it from your computer         system.

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>-- =
</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>Please =

see the official ORACLE-L FAQ: <A HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>-- =
</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>Author: =

lerobe - Lee Robertson
           = INET: LEROBE_at_acxiom.co.uk

SIZE=3D2>---------------------------------------------------------------=

-----

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>To REMOVE =
yourself from this mailing list, send an E-Mail message</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>to: =

ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>the =
message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>(or the =

name of mailing list you want to be removed from).  You may         also send = the HELP command for other information (like subscribing). -- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Boivin, Patrice J</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: BoivinP_at_mar.dfo-mpo.gc.ca</FONT>
</P>

Fat City Network Services    -- (858) = Received on Tue Nov 07 2000 - 12:29:54 CST