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

3 votes188 views2 answers
Get current year sql
SQL
0 vote245 views1 answer
Two inner joins sql
SQL
1 vote184 views1 answer
Mysql copy table1 to table2
SQL
1 vote186 views1 answer
Base nosql
SQL
23 votes196 views5 answers
Sql substring
SQL
1 vote183 views1 answer
Oracle add proxy
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
6 votes194 views4 answers
Mysql group by date
SQL
25 votes203 views5 answers
Uninstall mysql ubuntu
SQL
0 vote201 views1 answer
Helptext in sql
SQL