Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Suppressing a column
Oracle never lets you delete a column of a database table. But you can
use some work arounds Creating another table with a correct number of
columns, make an INSERT into <naew table> select <needed columns> from
<former table> statement, and dropping the former table.
|-----------------------------------------------------------------------------|Received on Fri Aug 28 1998 - 01:57:09 CDT
| If the only tool you have is a | Abiy Alemu abiy_at_biotec.jouy.inra.fr |
| hammer, everything in the world | 9, avenue calmels |
| seems like a nail.____________________| 92270 Bois colombes (France)________|