oracle drop column

1ALTER TABLE table_name DROP COLUMN column_name;

1ALTER TABLE my_table DROP COLUMN my_col;
2-- To check if column exists before renaming it:
3DECLARE
4    l_cnt INTEGER;
5BEGIN
6    SELECT count(*) INTO l_cnt
7    FROM dba_tab_columns		-- or all_tab_columns (depending on grants)
8    WHERE owner = 'my_schema' AND table_name = 'my_table' 
9    	AND column_name = 'my_col';
10    IF (l_cnt = 1) THEN
11        EXECUTE IMMEDIATE 'ALTER TABLE my_schema.my_table DROP COLUMN my_col';
12    END IF;
13END;

1alter table table_name drop column column_name;
2alter table table_name drop (column_name1, column_name2);