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 vote186 views1 answer
Sql developer search all packages for text
SQL
0 vote141 views0 answer
How to connect to datbase in springboot
SQL
1 vote172 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
7 votes169 views1 answer
Mysql unsafe update
SQL
0 vote188 views1 answer
Sql reverse order of results
SQL
8 votes184 views2 answers
How to fetch data from database without last column
SQL
8 votes205 views1 answer
Racle create auto increment column
SQL
1 vote193 views2 answers
Foreign key set 0
SQL
0 vote184 views2 answers
How to set global time_zone in mysql
SQL
3 votes186 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL