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 vote255 views1 answer
Stop mysql server mac
SQL
0 vote261 views1 answer
Mariadb mysql root access denied
SQL
1 vote303 views1 answer
Mysql select row max date
SQL
0 vote262 views1 answer
Sql query for displaying age from oldest to youngest
SQL
3 votes250 views4 answers
Show sql server database
SQL
14 votes286 views6 answers
Auto_increment mysql
SQL
1 vote268 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote271 views2 answers
How to tun mysql on ubunto
SQL
-1 vote292 views1 answer
Auto increment psql not primary key
SQL
3 votes276 views2 answers
Postgres alter table owner
SQL