Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Suppressing a column

Re: Suppressing a column

From: Abiy Alemu <abiy_at_biotec.jouy.inra.fr>
Date: Fri, 28 Aug 1998 08:57:09 +0200
Message-ID: <Pine.SOL.3.91.980828085429.16414A-100000@biotec>


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.

|-----------------------------------------------------------------------------|

| 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)________|
Received on Fri Aug 28 1998 - 01:57:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US