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

4 votes249 views2 answers
Select first and last row mysql
SQL
5 votes259 views1 answer
Find table from column name in sql
SQL
0 vote247 views1 answer
Hibernate with springboot mysql
SQL
3 votes263 views2 answers
Mysql config user password
SQL
0 vote286 views1 answer
Create table like sql
SQL
0 vote246 views1 answer
Sql select most frequent value in group
SQL
0 vote242 views1 answer
Select top 3 sql
SQL
0 vote260 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote259 views1 answer
Php get closest location by latitude longitude
SQL
8 votes267 views2 answers
Mysql get first x characters
SQL