Re: Change the number size.

David Cui wrote:
>
> Dear netters:
>
> The title sounds confusing. What I intend to do is
> I have a table A with a field B. B is a number (12),
> I want to change the definition of B to be a number(6)
> say. Or I have a field of number, I want to change it to
> number (12) or to a float. What should I do?
>
> David Unless, I'm mistaken; if the table already has data in it,
Oracle will not allow you to reduce the size of a field or change it's data type. Sounds like you will have to unload the data in the table and insert it into a new table with the proper data types and sizes.

-- 
James Cummings
jc1635_at_mail.airmail.net