In article <tcafg8gursgofe_at_corp.supernews.com>, Tao Y. Ge
<tao_at_nextengine.com> writes:
>Hi,
>
>I am looking for the Oracle equivalent of the MSSQL's DATALENGTH function.
>
>in mssql if I do a SELECT DATALENGTH(blobcolumn) from TABLENAME
>I get back a list of sizes of those BLOBs.
>
>How would I do something similar in ORACLE?
>
>any help will be greatly appreciated.
>thanks.
>
>--
>
>Tao Ge
>Software Engineer
>tao_at_nextengine.com
>(310) 883-1837
>
>NextEngine, Inc.
>401 Wilshire Blvd., Ninth Floor
>Santa Monica, California 90401
>
Look at the dbms_lob package getlength function for finding the length of LOB
column data. I do not have a set of manuals handy but there is a chapter on
dbms_lob package in the ver 8 Application Programmers Guide that may interest
you.
- Mark D. Powell --
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Sat Mar 31 2001 - 16:06:48 CST
