How to delete column in oracle?

How to delete a column in oracle: 1. Delete a column, the code is [ALTER TABLEtable_name DROP COLUMNcolumn_name;]; 2. Delete multiple columns, the code is [ALTER TABLE table_name DROP(column1,].

Oracle method to delete a column:

1. Delete a column

ALTER TABLE table_name DROP COLUMN column_name;

2. Delete multiple columns

ALTER TABLE table_name DROP (column_1,column_2,...);

Extended information:

1.Add a column

ALTER TABLE table_name ADD column_1 DATE NOT NULL; 
ALTER TABLE table_name ADD column_2 VARCHAR2(44) DEFAULT ''; 
ALTER TABLE table_name ADD column_3 number(28,10);

2. Add a column

ALTER TABLE table_name
    ADD (
        column_1 type constraint,--列名 类型 约束
        column_2 type constraint,
        ...
    );

Related learning recommendations: oracle database learning tutorial

The above is the detailed content of How to delete column in oracle?. For more information, please follow other related articles on the PHP Chinese website!