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 vote162 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
-1 vote139 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote191 views3 answers
Select top 10 rows in sql
SQL
32 votes136 views6 answers
Insert select
SQL
0 vote133 views1 answer
How to find username and password in oracle 18c
SQL
0 vote200 views1 answer
Import sql dump into postgresql database
SQL
0 vote158 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote143 views1 answer
Oracle array
SQL
0 vote141 views1 answer
Change date in pivot table to month in sql server
SQL
2 votes124 views2 answers
Get all columns from table sql
SQL