Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: datalength
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
![]() |
![]() |