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 -> How to get the size of a BLOB column

How to get the size of a BLOB column

From: Tao Y. Ge <tao_at_nextengine.com>
Date: Fri, 30 Mar 2001 18:12:43 -0800
Message-ID: <tcafg8gursgofe@corp.supernews.com> 






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


Received on Fri Mar 30 2001 - 20:12:43 CST












Original text of this message













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