>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao