Last post Mar 28, 2006 09:20 PM by codeboy
Mar 21, 2006 10:15 PM|Dryden|LINK
Mar 28, 2006 09:20 PM|codeboy|LINK
You can use dbms_lob for this, there's a getlength function that will return you the sql length of the lob value you pass to it. For example: (this is using 9iR2 but it should work with at least 8iR3 and presumably newer versions)
SQL> desc pm.print_media;
SQL> select dbms_lob.getlength(ad_photo) from pm.print_media;
Hope this helps!