Re: CLOB question

  • From: "Lou Fangxin" <anysql@xxxxxxxxx>
  • To: FAKTORG@xxxxxxxxx
  • Date: Sun, 13 Aug 2006 14:08:51 +0800

empty_clob() will use 16 bytes. while NULL just 1 byte

On 8/10/06, Greg Faktor <FAKTORG@xxxxxxxxx> 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@xxxxxxxxx> 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2006