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).
Received on Sun Nov 09 2003 - 00:09:25 CST
