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 vote309 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
4 votes272 views1 answer
SQL order random
SQL
0 vote285 views1 answer
Display first three characters sql
SQL
0 vote320 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote287 views1 answer
Mysql_error replacement
SQL
5 votes293 views1 answer
Oracle create table comment
SQL
1 vote289 views1 answer
Show per page table in xampp
SQL
0 vote244 views1 answer
Ms sql print more than 1 variable
SQL
1 vote301 views1 answer
Postgresql pass array in function
SQL
3 votes246 views2 answers
Mysql sum with condition
SQL