Re: CLOB distinct Problem

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 18 Apr 2006 09:32:43 -0400
Message-ID: <TNGdncXNNP_md9nZRVn-gw@comcast.com>

"Kuldeep" <kuldeepchitrakar_at_gmail.com> wrote in message news:1145365073.869769.52530_at_j33g2000cwa.googlegroups.com...
: *****Oracle*******
: I am selecting distinct records from a table, but table has one column
: whose datatype is CLOB, so i got errors in select.
: does anybody have solution over it.
:
: select distinct * from dept.
:
: dept structure::
:
: id varchhar(5)
: name char (30)
: message CLOB
:

post your DB version and the actual error (after first looking up the error in google or the Oracle Reference manual)

++ mcs Received on Tue Apr 18 2006 - 08:32:43 CDT