Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> CLOB distinct Problem

CLOB distinct Problem

From: Kuldeep <kuldeepchitrakar_at_gmail.com>
Date: 18 Apr 2006 05:57:53 -0700
Message-ID: <1145365073.869769.52530@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 Received on Tue Apr 18 2006 - 07:57:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US