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

3 votes268 views1 answer
Mysql replace string in table
SQL
1 vote278 views1 answer
Partition by sql server
SQL
0 vote267 views1 answer
Sqlalchemy case insensitive like
SQL
2 votes237 views1 answer
Latest record in sql
SQL
1 vote287 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
10 votes272 views2 answers
Show tables in schema oracle
SQL
3 votes280 views1 answer
Null sql
SQL
13 votes263 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
1 vote254 views1 answer
Sql only five first row
SQL
0 vote298 views1 answer
SQL-Arten
SQL