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

0 vote206 views1 answer
Get the previous column of a table in mysql
SQL
13 votes202 views2 answers
Sqlite rename column
SQL
5 votes242 views2 answers
Functions
SQL
2 votes233 views1 answer
Python sql
SQL
0 vote210 views1 answer
Prodection ready postgres database step by step
SQL
0 vote245 views1 answer
Mysql order by where condition sub query
SQL
1 vote199 views1 answer
Reutrn string after character sql
SQL
0 vote219 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote204 views1 answer
Sql cursor example multiple columns
SQL
0 vote216 views1 answer
Search db for table name
SQL