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 vote236 views1 answer
Find logged in users mysql
SQL
0 vote272 views1 answer
Sql select column name like from multiple tables
SQL
-1 vote265 views1 answer
Mysql change database charset and collation
SQL
4 votes256 views1 answer
SQL find text in SP
SQL
0 vote261 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote253 views1 answer
Datagrip go to line
SQL
0 vote272 views1 answer
Get last three characters in mysql column
SQL
1 vote260 views1 answer
Get last week data in mysql
SQL
2 votes265 views5 answers
SQL trigger
SQL
17 votes242 views6 answers
Sql current date
SQL