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

2 votes355 views2 answers
Storing timezones in postgres
SQL
1 vote332 views1 answer
Sql query row number group by
SQL
0 vote344 views1 answer
Select all columns except one sql
SQL
10 votes397 views4 answers
Join multiple tables in sql
SQL
1 vote348 views1 answer
Oracle sql average
SQL
1 vote372 views1 answer
Import mysql dump database command line linux
SQL
0 vote339 views1 answer
ORACLE PARSE STRING
SQL
0 vote337 views1 answer
Limiting query result using where in sql
SQL
1 vote312 views1 answer
Postgresql update auto_increment value
SQL
2 votes325 views3 answers
Mysql list tables by size
SQL