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 vote107 views1 answer
Sql sort ages
SQL
0 vote102 views1 answer
Sql show all users
SQL
0 vote111 views1 answer
Sql server user permissions and roles
SQL
0 vote118 views2 answers
How to generate a unique random number in mysql
SQL
3 votes110 views1 answer
Only join in sql
SQL
0 vote115 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
27 votes228 views3 answers
Mysql delete row
SQL
7 votes99 views2 answers
Show size database mysql
SQL
0 vote113 views1 answer
IS THEre any difference between using default and := in plsql
SQL
3 votes110 views1 answer
Oracle list dates without weekends
SQL