Re: check 1 row blob size

From: hehehe <m_at_m.ccc>
Date: Fri, 2 Oct 2009 13:17:49 +0200
Message-ID: <ha4ngu$1ucr$1_at_news2.ipartners.pl>

select dbms_lob.GETLENGTH(column_with_blob) from table;

works! :-)

U¿ytkownik "hehehe" <m_at_m.ccc> napisa³ w wiadomo¶ci news:ha4big$1o5g$1_at_news2.ipartners.pl...
>I have a table name TEST on that table i have 10 rows every row have a
>blob. Id like to know how to check every lob size
>
> 1 10kb test1
> 2 15kb test2
> 3 15kb test3
> 4 25 kb
> 5 30kb
> ...
>
> pls help create some select...
>
> regards -heehhe
>
Received on Fri Oct 02 2009 - 06:17:49 CDT