>>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
>
>You need to specify the largest possible value within your data.
>
>FWIW, an integer can be + or - 2147483647 so you need to specify 10 so the corresponding result set creates a N(10,0) for storage.
Since it may be negative, wouldn't you need 11 N(11,0)?