What SQL I have to use.Is there any way can i know what are those columns
were updated thru EMPTY_CLOB() function?
Thx
-Seema
>From: Vladimir Begun <vladimir.begun_at_oracle.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Select ?
>Date: Sat, 08 Nov 2003 22:09:25 -0800
>
>get length of each of those you will see which one you need.
>length of #4 should be 0.
>--
>Vladimir Begun
>The statements and opinions expressed here are my own and
>do not necessarily represent those of Oracle Corporation.
>
>Seema Singh wrote:
>
>>Hi,
>>If we have table with clob column and want to findout whcih clob column
>>rows has been updated/inilialised thru empty_clob() functions? How to do
>>that?
>>
>>Like table with 2 columns ID and testcolu .ID is
>>desc test_table
>>Name Null?
>>Type
>>----------------------------------------------------------------- --------
>>--------------------------------------------
>>ID
>>NUMBER(16)
>>TESTCOLU CLOB
>>
>>Having rows like
>>
>> ID TESTCOLU
>>----------
>>--------------------------------------------------------------------------------
>>
>> 1 aaaaaaaa
>> 2 aaaaaaaa
>> 3
>> 4
>> 99
>>
>>Out of these 5 rows id# 4 were inilialised thru EMPTY_CLOB()
>>function.Wondering which sql statement would pickup only those rows having
>>id value 4 .
>>The ID 3 was inilialised thru NULL and 99 was with ' '.
>>thanks in advance.
>>-Seema
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Vladimir Begun
> INET: vladimir.begun_at_oracle.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Is your computer infected with a virus? Find out with a FREE computer virus
scan from McAfee. Take the FreeScan now!
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Seema Singh
INET: oracledbam_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Nov 09 2003 - 23:59:25 CST
