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

0 vote348 views1 answer
Sql column as header
SQL
0 vote361 views1 answer
Sql shell psql cannot enter password
SQL
1 vote368 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote378 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
2 votes359 views2 answers
Created at and updated at in mysql
SQL
2 votes424 views3 answers
Mysql unix timestamp to date
SQL
1 vote371 views1 answer
Psql connect
SQL
2 votes352 views1 answer
Oracle calculated column
SQL
0 vote340 views1 answer
Get record which is available in one table but not in another mysql
SQL
3 votes360 views2 answers
Enter mysql command line
SQL