All,

I have a SQL view using NVL to eliminate .NULLs. from the view fields. I am getting a "View definition has been changed" error message. I think the NVL for the integer types may not have the correct field length.

How many zeros do I need to use in the NVL to represent an integer?

TIA

Rex