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

7 votes246 views1 answer
Grant schema permissions postgres
SQL
0 vote257 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote299 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
5 votes270 views1 answer
AND OR NOT operators sql
SQL
5 votes268 views4 answers
Mysql on duplicate key update
SQL
9 votes257 views4 answers
How to remove duplicate in sql
SQL
0 vote278 views2 answers
How to add CHECK constraint to a column in postgres
SQL
-1 vote268 views1 answer
Sql oracle take only last results
SQL
0 vote250 views1 answer
Trim sql oracle
SQL
0 vote293 views1 answer
Mysql record group by created date count
SQL