Re: Change the number size.

ALTER TABLE a

        MODIFY ( b NUMBER(6) );

Note(SQL Lang Ref. Manual P:4-74):
You can change a column's datatype
or decrease a column's size only
if the colum contains null
in all rows. However you can always
increase the size of a character or raw column or the precision of a numeric column.

-Kittu

David Cui (cui_at_solaria.sol.net) 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
Received on Tue Apr 23 1996 - 00:00:00 CEST