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: Greg Faktor <FAKTORG_at_wyeth.com>
Date: Wed, 09 Aug 2006 13:43:42 -0400
Message-Id: <s4d9e69e.071@gvn002m.gv.us.pri.wyeth.com>


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 OSAny 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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 09 2006 - 12:43:42 CDT

Original text of this message

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