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 vote207 views1 answer
Sql select all tables from database change url
SQL
0 vote195 views1 answer
Lost connection to mysql
SQL
0 vote226 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote216 views1 answer
Postgresql contains
SQL
0 vote206 views1 answer
Sql change date format
SQL
13 votes218 views3 answers
Insert mysql ifile nto database
SQL
2 votes192 views1 answer
Sql server conection string
SQL
10 votes243 views4 answers
Join multiple tables in sql
SQL
0 vote197 views1 answer
Postgres jsonb array push new element
SQL
0 vote190 views1 answer
Dasebase_url-postgres for windows
SQL