Re: Can Oracle drop a column?

instead of using insert statements you can write a ddl as follows : if your original table has columns a, b, c and d and you want drop c then your statements would be -
create table temporary_table as select a, b, d from original_table; drop table original_table;
rename temprary_table to original_table; hope that helps.
Deb. Received on Thu Jul 03 1997 - 00:00:00 CDT