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 vote139 views1 answer
Sql count null as 0
SQL
13 votes144 views1 answer
Views in sql
SQL
0 vote141 views1 answer
Search from comma separated values in sql server
SQL
0 vote175 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
8 votes138 views2 answers
Phpmyadmin default password
SQL
2 votes140 views1 answer
Sql column values comma separated
SQL
1 vote178 views1 answer
Oracle select first row order by
SQL
2 votes186 views1 answer
Show max_allowed_packet mysql
SQL
0 vote143 views1 answer
Sql delete from with relation
SQL
-1 vote132 views1 answer
Plsql while
SQL