Path: news.f.de.plusline.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!a75g2000cwd.googlegroups.com!not-for-mail
From: "samir.vds@googlemail.com" <samir.vds@googlemail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: need sql query to check if a column is unique
Date: 28 Feb 2007 04:00:08 -0800
Organization: http://groups.google.com
Lines: 6
Message-ID: <1172664008.469989.185480@a75g2000cwd.googlegroups.com>
References: <1172657286.681146.193290@p10g2000cwp.googlegroups.com>
   <45e55fa5$0$17986$dbd43001@news.wanadoo.nl>
NNTP-Posting-Host: 193.254.155.48
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1172664016 19151 127.0.0.1 (28 Feb 2007 12:00:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 28 Feb 2007 12:00:16 +0000 (UTC)
In-Reply-To: <45e55fa5$0$17986$dbd43001@news.wanadoo.nl>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: a75g2000cwd.googlegroups.com; posting-host=193.254.155.48;
   posting-account=ai06yQ0AAAD6ydjIliNss1yEA7H-IjiE
Xref: news.f.de.plusline.net comp.databases.oracle.server:194712

Ok, thanks. I wasn't familiar with the having keyword, but now I got
it.

Of course a unique constraint would be preferable, but the guys of our
Data Warehouse departement are quite lazy :D