Oracle sql drop column if exists

DECLARE
  l_cnt NUMBER;
BEGIN
  SELECT COUNT(*) INTO l_cnt 
    FROM dba_tab_columns
   WHERE owner = 'my_owner'
     AND table_name = 'my_table' AND column_name = 'my_column';
  IF( l_cnt = 1 ) THEN
    EXECUTE IMMEDIATE 'ALTER TABLE my_table DROP COLUMN my_column';
  END IF;
END;

Similar codes

0 vote339 views1 answer
Mysqldump: error:
SQL
-1 vote302 views1 answer
Mysql change database charset and collation
SQL
1 vote317 views1 answer
Is sql fast
SQL
2 votes374 views5 answers
Tablespace ORACLE
SQL
10 votes316 views3 answers
Join multiple tables sql
SQL
2 votes329 views1 answer
Sql server: select column values as comma separated string
SQL
20 votes323 views6 answers
Mysql reset auto increment
SQL
0 vote288 views2 answers
Mysql disable foreign key checks
SQL
3 votes329 views3 answers
Mysql declare variable
SQL
0 vote302 views1 answer
Postgres sql alter table delete row
SQL