oracle number datatype
Posted on 2011-03-02
Experts... I have a database column which is of number(10,3) type. If there is no value stored in this column and I need to check in a PL/SQL block if there is any value or not how do I do it. I cannot use NVL or NVL2 becuase if there is no value stored I need to return blank in the return variable. Only if there is a value either 0 or greater then I need to return that value in the return variable.