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 vote333 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote305 views4 answers
Sql limit 1 offset 1
SQL
0 vote300 views1 answer
How much table store postgres
SQL
12 votes310 views4 answers
Mysql version query
SQL
13 votes303 views2 answers
Oracle inner join
SQL
1 vote348 views3 answers
Date_add mysql
SQL
-1 vote317 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
1 vote297 views1 answer
Sql week commencing date
SQL
2 votes323 views1 answer
Removing view
SQL
7 votes320 views3 answers
Python and mysql connectivity
SQL