tag:blogger.com,1999:blog-1271763227002553835.post6514352380668692010..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: An Empty Clob is not NULL, it's NOT NULLAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1271763227002553835.post-88284320058174660122010-04-29T14:39:27.267+02:002010-04-29T14:39:27.267+02:00Just thought I'd let you know that you can use...Just thought I'd let you know that you can use "dump" on clobs e.g.<br /><br />dump(anydata.convertclob(text))<br /><br />Cheers<br />MattAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-90164864377818858942009-11-23T10:39:03.849+01:002009-11-23T10:39:03.849+01:00Hi Alex,
Maybe not the quickest solution, but thi...Hi Alex,<br /><br />Maybe not the quickest solution, but this works too:<br /><br />select *<br />from test<br />where dbms_lob.compare(nvl(text, empty_clob()),empty_clob())= 0<br /><br />see ya<br />PeterAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-37818225089187113712009-11-13T21:00:33.352+01:002009-11-13T21:00:33.352+01:00You can kinda see why there has been a little resi...You can kinda see why there has been a little resistance to the take-up of LOBs. There are a few little gotchas like this that jump out and surprise you when you least expect it. :)<br /><br />Cheers<br /><br />Tim...Tim...https://www.blogger.com/profile/17721555946005999179noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-18185034305547075932009-11-13T09:34:01.211+01:002009-11-13T09:34:01.211+01:00very nice solution Alex... I like the NULLIF and I...very nice solution Alex... I like the NULLIF and I must admit I hardly ever use that function, but now I've a nice use case ;)<br /><br />Thanks,<br />DimitriDimitri Gielishttp://dgielis.blogspot.comnoreply@blogger.com