How to Retrieve the CLOB data when using DISTINCT Keyword for other columns
I have one query regarding how to retrieve the CLOB data.
The requirement is something that in the select statement there are around 20+ columns which i need to retrieve from around 5 tables after joining.
Since the result set after joining also will get duplicate values i need to use distinct keyword to filter the resultset.
But in the 20+ columns there are 2 CLOB data columns which i need to retrieve.
Whenever i use DISTINCT i'm getting ORA-00932: inconsistent datatypes: expected - got CLOB error.
I know that DISTINCT keyword cannot be used for CLOB datatypes.
So can anyone help me out here with any work around/ alternate way to get the CLOB value in the SELECT QUERY.
So please help me out in this.