Oracle drop column

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

Oracle alter table delete column

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

Source: oracle-base.com

Similar codes

1 vote207 views1 answer
Oracle transaction rollback not working
SQL
5 votes166 views1 answer
Oracle generate list of dates in between a date range
SQL
2 votes133 views1 answer
Oracle index size calculation
SQL
2 votes165 views3 answers
Row number mssql
SQL
25 votes153 views4 answers
Sqlserver add column
SQL
0 vote146 views1 answer
Psql list view rules
SQL
3 votes215 views3 answers
Mysql get table size
SQL
0 vote141 views1 answer
Connexion mysql
SQL
3 votes152 views1 answer
Force using index plsql
SQL
0 vote163 views1 answer
How to subquey to do not load in live database in
SQL