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

1 vote203 views2 answers
Into sql
SQL
0 vote257 views1 answer
Mysql convert charset
SQL
0 vote231 views1 answer
Login failed for user sql server
SQL
8 votes231 views2 answers
Select table column name in sql
SQL
2 votes221 views1 answer
Oracle index size calculation
SQL
4 votes228 views1 answer
Oracle delete last row
SQL
0 vote226 views1 answer
Knex last insert id mysql
SQL
0 vote249 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote225 views1 answer
Sqlite update where exists
SQL
0 vote224 views1 answer
Mysql repair a table
SQL