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 vote262 views1 answer
Sql delete row from table where id
SQL
0 vote185 views1 answer
Get db connection detail from sql developer profile
SQL
13 votes171 views6 answers
Restart postgresql
SQL
5 votes769 views1 answer
Oracle ora-00054 find
SQL
1 vote287 views1 answer
Alter constraint postgres
SQL
2 votes181 views1 answer
Update trigger
SQL
0 vote240 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote214 views1 answer
Hackerrank sql test solutions
SQL
0 vote204 views1 answer
Allow null in psql
SQL
0 vote196 views1 answer
Python connect to mysql in settings.py
SQL