[rt-devel] A bit of oracle clue?
Jesse
jesse at fsck.com
Fri Mar 30 03:19:44 EST 2001
From where I sit, that's not valid SQL syntax. (mysql rejects it).
How's life in petersburg?
-j
On Thu, Mar 22, 2001 at 11:25:24AM +0100, Tobias Brox wrote:
> > Anyone have a helpful
> > suggestion for how to make oracle happy with this:
> >
> > SELECT DISTINCT * from Tablename;
> >
> > Thanks,
> > Jesse
>
> I've never tried Oracle, but I'd suggest trying this:
>
> SELECT UNIQUE(*) from Tablename;
>
>
>
--
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
autoconf is your friend until it mysteriously stops working, at which
point it is a snarling wolverine attached to your genitals by its teeth
(that said, it's better than most of the alternatives) -- Nathan Mehl
More information about the Rt-devel
mailing list