Home » SQL & PL/SQL » SQL & PL/SQL » find the length of type clob
find the length of type clob [message #9040] Tue, 14 October 2003 19:40 Go to next message
Yi Xu
Messages: 5
Registered: October 2003
Junior Member
What's the function to find the length of a type clob column? I'm getting an error "Inconsistent Datatype" when running the following statement:

select length(column) from table

Report message to a moderator

Re: find the length of type clob [message #9041 is a reply to message #9040] Wed, 15 October 2003 01:19 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Use the DBMS_LOB.GETLENGTH() function.

MHE

Report message to a moderator

Previous Topic: datatype for JPEG image
Next Topic: DECODE and Boolean
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 05:59:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.