Re: SELECT A CLOB - GROUP BY

[Quoted] On Wednesday, 9 April 2008 13:23:51 UTC+5:30, Shakespeare wrote:
> <trpost_at_gmail.com> schreef in bericht
> news:e2cb990f-1c6f-40ac-b154-c89f864104e8_at_n58g2000hsf.googlegroups.com...
> > Is there anything that can be done with a PLSQL function to convert a
> > CLOB to a VARCHAR2 to a size larger than 4000 characters? I read that
> > PLSQL can handle a VARCHAR2 with 32767 charcaters, so is it possible
> > to write a function to return this conversion?
> >
> > I found the following, but couldn't get it to compile:
> >
> > CREATE OR REPLACE FUNCTION GetVarchar2 (iclCLOB IN OUT CLOB)
> > return VARCHAR2
> > IS
> >
> > cnuMAX_LENGTH Constant number := 32767 ;
> > nuLength Number := DBMS_LOB.getlength(iclCLOB);
> > sbBuffer varchar2(32767);
> >
> > DBMS_LOB.read(iclCLOB,nuLength,1,bBuffer);
> > return sbBuffer;
> > END
> >
> > Thanks
> >
>
> Is the case_list the same for every 'PRODUCT_NAME'?
> If it is, don't select it on forehand, but do the group by first and then
> look up the case list
> If it's not, it makes no sense to do a group by at all.
>
> Shakespeare

I want to use group by function onm CLOB as I want to match part of one CLOB data to another.Can anyone please help Received on Tue Jun 23 2015 - 09:02:46 CEST