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 vote372 views1 answer
FIND most frequent word in sql server
SQL
0 vote299 views2 answers
Spring properties file for db
SQL
10 votes328 views2 answers
Sql rtrim
SQL
10 votes378 views4 answers
Mysql if else
SQL
0 vote332 views1 answer
Mssql check if date is greater than today
SQL
0 vote335 views1 answer
Sql trying to delete database in use
SQL
0 vote356 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote357 views1 answer
Query to remove duplicate rows from a table
SQL
1 vote341 views1 answer
Oracle repeat_interval 5 minutes
SQL
2 votes336 views2 answers
Compare date mysql
SQL