Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: CLOB question

Re: CLOB question

From: Lou Fangxin <anysql_at_gmail.com>
Date: Sun, 13 Aug 2006 14:08:51 +0800
Message-ID: <ea5907d30608122308l2a003e62l6f7dc85d24775541@mail.gmail.com>


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

Original text of this message

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