[rt-devel] A bit of oracle clue?

[Marco Nijdam]

Jesse,

Can you explain why you need this statement?

Apparently you have doubles in the database, and want to get rid of it?
What is the use of having doubles in the database anyway?

Or do you need a distinct for a join over multiple tables?

Can't you work around it by sorting the select and removing doubles
in the Perl code?

In Oracle you can not work with the contents of CLOBS, BLOBS, and for that
matter the LONG datatype, in queries directly. I'm not sure how the
Perl module solves this, but in Java or PL/SQL you get a reference to
the CLOB or BLOB from the select, and do some magic handwaving to
get the contents of the CLOB/BLOB based on this reference.

> Anyone have a helpful
> suggestion for how to make oracle happy with this:
> 
> SELECT DISTINCT * from Tablename;
> 
> Thanks,
>         Jesse

Kind regards,
--
-- Marco Nijdam,         marco at west.nl
-- West Consulting B.V., Delftechpark 5, 2628 XJ  Delft, The Netherlands
--                       P.O. Box 3318, 2601 DH  Delft
-- Tel: +3115 219 1600,  Fax: +3115 214 7889