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 vote295 views1 answer
Sql select min
SQL
4 votes288 views1 answer
Force drop all tables postgres
SQL
0 vote287 views1 answer
Grouping by email domain mysql
SQL
-1 vote286 views3 answers
Check table exist postgresql
SQL
6 votes276 views1 answer
Sqlite foreign key
SQL
0 vote303 views1 answer
Print mysql
SQL
0 vote295 views1 answer
Python connect microsoft sql server
SQL
2 votes348 views1 answer
Sql compare strings
SQL
5 votes306 views2 answers
Postgres update with if condition query
SQL
1 vote280 views1 answer
Oracle list datafiles in tablespace
SQL