Skip to Main Content
Forums

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!

How to check if CHAR(X BYTE) field is empty

651794Jul 25 2008 — edited Jul 26 2008
Hi

Could anyone let me know how should I test a CHAR field for null values.

I tried sql as decode(field,' ',field2,field) but it doesnt seem working.

Thanks in advance

stefen
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2008
Added on Jul 25 2008
8 comments
1,063 views