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 vote176 views1 answer
Sql count matching group by
SQL
0 vote137 views1 answer
How to use sqlcommand
SQL
0 vote134 views1 answer
Android sqlite get rows count
SQL
0 vote137 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote130 views1 answer
Soql more than today
SQL
3 votes142 views3 answers
Docker create postgresql database
SQL
0 vote147 views1 answer
Mysql grouping functions
SQL
2 votes160 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote127 views1 answer
Check if a word appears at the end sql query
SQL
0 vote143 views1 answer
How to add unique key constraint in mysql
SQL