Re: drop column

The DROP option is for dropping constraints.

1. You could create a new_table AS Select col1, col2, col3 from old_table
2. You could also spool the table (specifying columns) to a text file, then use SQL*LOADER to bring it back into oracle

Michael Ginzburg wrote in message <7i93p7$l3h$1_at_news.netvision.net.il>...
>Hi!
>
>How to drop column in Oracle? I haven't found such operation in ALTER
TABLE?
>
>
Received on Mon May 24 1999 - 01:24:26 CEST