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!

NA value in number field

779066Jun 23 2010 — edited Jun 23 2010
Hi all,

It was a interview qsn..

In a number field, if there is no value it shows 'NULL'. but how to show 'NA' instead of 'NULL' when the field is integer?? It means how to show 'NA' in an integer field.

Plz help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2010
Added on Jun 23 2010
12 comments
3,505 views