Re: SELECT A CLOB - GROUP BY

<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 Received on Wed Apr 09 2008 - 02:53:51 CDT