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

14 votes295 views4 answers
Online sql compiler
SQL
0 vote242 views3 answers
Mysql calculate age from date of birth
SQL
2 votes281 views1 answer
Possgress drop if exists table
SQL
1 vote296 views1 answer
Sql select max value from multiple rows
SQL
2 votes322 views1 answer
Create mysql user on all hosts
SQL
23 votes277 views3 answers
Mysqldump
SQL
0 vote336 views1 answer
Tsql cte in a transaction
SQL
2 votes294 views1 answer
Mysql sysdate - 1 day
SQL
3 votes266 views1 answer
Mysql UPDate with enner join
SQL
0 vote310 views1 answer
Postgresql list extensions
SQL