Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check a BLOB for NULL

LafJun 19 2009 — edited Jun 19 2009
Hi,

I have a BLOB field in my table, and I want to test it for NULL. What is the best way to do it? I want to use a SELECT statement if possible...

I tried with DECODE bu got an error !

Thanks in advance,

Marc.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2009
Added on Jun 19 2009
4 comments
6,908 views