What's the best way to change the column data type from varchar2 to
number? I am contemplating two options:

1) ALTER TABLE . . .

2) Create a new column, populate the new column from the old column,
and then drop the old column.

Any suggestions would be appreciated!

Brad


Oracle LazyDBA home page