empty_clob() will use 16 bytes. while NULL just 1 byte
On 8/10/06, Greg Faktor <FAKTORG_at_wyeth.com> wrote:
>
> Looks like I should look on default value for clob column. If it has
> empty_log() default then they are using it.
>
> Thanks.
>
> >>> "Greg Faktor" <FAKTORG_at_wyeth.com> 8/9/2006 12:33:52 PM >>>
>
>
> Hi All!
>
>
>
> Oracle 9.2, Sun OS
>
> Any way to find out, from database, what has been used to populate some
> clob column?
>
> Basically I need to find out if during insert NULL value or empty_clob()
> functions have been used?
>
>
> I far as I understand empty_clob() use much less space than regular NULL
> value.
>
> Thanks.
> Greg
>
--
Welcome!
Home: http://www.IamDBA.com
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Aug 13 2006 - 01:08:51 CDT
