What is the use of VALUE function?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the use of VALUE function?

Avoid negative SQLCODEs by handling nulls and zeroes in computations. Substitute a numeric value for any nulls used in computation

(Continued on next question...)

Other Job Interview Questions

• What are foreign keys?
• Why SELECT * is not preferred in embedded SQL programs ?
• What are the column name qualifiers?
• Why SELECT * is not preferred in embedded SQL programs ?
• What is UNION, UNION ALL?
• What is a view? Why use it ?
• What are the wildcard characters ?
• What is referential integrity?
• What are some SQL aggregates and other built-in functions?
• Describe referential integrity?
• More...