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 vote214 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
10 votes201 views1 answer
Oracle dependency
SQL
0 vote223 views1 answer
How to select an index in oracle sql
SQL
0 vote216 views1 answer
Postgres truncate with cascade
SQL
1 vote243 views2 answers
This month mysql where
SQL
2 votes237 views2 answers
Postgresql get table names
SQL
7 votes220 views3 answers
Restore postgres database from sql file
SQL
0 vote206 views1 answer
Can we rollback data that are deleted using DELETE
SQL
-1 vote248 views1 answer
Mysql faster insert
SQL
0 vote230 views1 answer
Create table with primary key and foreign key in sql server
SQL