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

12 votes333 views3 answers
Duplicate a column in sql
SQL
1 vote377 views1 answer
Setval pgsql
SQL
4 votes323 views1 answer
Mac install mysql
SQL
0 vote363 views1 answer
Resullt all update knex mysql
SQL
0 vote360 views1 answer
Create a table from one field of another table
SQL
12 votes354 views4 answers
Mysql get date difference in hours
SQL
3 votes328 views1 answer
Difference sql vs mysql
SQL
0 vote389 views1 answer
Querry mysql by 2 columns
SQL
4 votes333 views1 answer
SQL order random
SQL
0 vote373 views1 answer
Drop database using terminal postgres
SQL