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;

Source: grepper.com

Similar codes

1 vote297 views1 answer
Limit offset order by mysql
SQL
2 votes298 views1 answer
How to select first row of database sql
SQL
1 vote328 views1 answer
Postgres check blocking
SQL
0 vote388 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
1 vote304 views1 answer
Lpad function in sql oracle
SQL
0 vote318 views1 answer
Sql add calculated column
SQL
0 vote313 views1 answer
Postgresql not in alternative
SQL
1 vote314 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote327 views1 answer
Python list from sql
SQL
0 vote332 views1 answer
How to get nth number in sql
SQL