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

Home -> Community -> Usenet -> c.d.o.server -> Re: datalength

Re: datalength

From: tojo <tom_at_hotmail.com>
Date: Wed, 6 Feb 2002 16:25:48 +0100
Message-ID: <MPG.16cb696861083c8c9896a6@news.t-online.de>


Check the docs for the DBMS_LOB package. There you'll find a function called GETLENGTH().

In article <3C613E73.60009_at_inf.tu-dresden.de>, ag17_at_inf.tu-dresden.de says...
> under mssql is a function called DATALENGTH, retrieving the length of an
> expression, i.e. length of a VARCHAR column.
> now under oracle, where i have CLOB and BLOB instead of VARCHAR /
> VARBINARY i need a similiar function.
> the oracle functions LENGTH and VSIZE cannot handle this. any suggestions?!
>
>
Received on Wed Feb 06 2002 - 09:25:48 CST

Original text of this message

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