HELP: changing column width
From: Ned Hamilton <esh6n_at_brain.neuro.virginia.edu>
Date: Tue, 13 Dec 1994 21:10:03 GMT
Message-ID: <D0rpGr.FnB_at_murdoch.acc.Virginia.EDU>
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
Received on Tue Dec 13 1994 - 22:10:03 CET
Date: Tue, 13 Dec 1994 21:10:03 GMT
Message-ID: <D0rpGr.FnB_at_murdoch.acc.Virginia.EDU>
Does anyone know of an easy way to change the scale of a column in a table from NUMBER to NUMBER(x, y)? Because the original column was created with the default precision for NUMBER of 38, any change to add scale will reduce the precision. And since there's data in the column, I can't do an ALTER TABLE MODIFY.
Only way I know of is to write data out, change the table, then read the data back in.
I don't want to create a dummy column and swap the data back and forth.
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
Ned Hamilton NTC Department of Neurosurgery nedh_at_virginia.edu University of Virginia
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
Received on Tue Dec 13 1994 - 22:10:03 CET