Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!tut.cis.ohio-state.edu!ucbvax!pasteur!eden.Berkeley.EDU!mao
From: mao@eden.Berkeley.EDU (Mike Olson)
Newsgroups: comp.databases
Subject: Re: Duplicated tuples problem (Oracle/SQL)
Message-ID: <10007@pasteur.Berkeley.EDU>
Date: 3 Jan 91 06:00:12 GMT
References: <772@keele.keele.ac.uk> <CIMSHOP!DAVIDM.90Dec21095239@uunet.UU.NET> <12224@sybase.sybase.com> <775@keele.keele.ac.uk>
Sender: news@pasteur.Berkeley.EDU
Reply-To: mao@eden.Berkeley.EDU (Mike Olson)
Organization: University of California, Berkeley
Lines: 17

In <775@keele.keele.ac.uk>, csa18@seq1.keele.ac.uk (R.J. Husmo) writes
(regarding the removal of duplicates from tables under oracle)

> We do not know the format of the tables involved

the query

	SELECT * FROM FOO WHERE 1 = 0

returns the target list for queries on foo; although it doesn't solve your
whole problem, it is a useful query to know when you want to know what a
table contains without looking at any tuples.

					mike olson
					postgres research group
					uc berkeley
					mao@postgres.berkeley.edu