[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