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 vote273 views1 answer
Hierarchal database table
SQL
0 vote220 views1 answer
How to drop a trigger in postgresql
SQL
2 votes209 views3 answers
3 days back in sql server
SQL
0 vote229 views1 answer
ORA-13717
SQL
0 vote230 views1 answer
Implicit inner join table alias
SQL
0 vote235 views1 answer
How to get nth number in sql
SQL
0 vote232 views1 answer
Edit shchima table in sql
SQL
0 vote240 views1 answer
Hour differeence in mysql
SQL
1 vote208 views1 answer
Select 2 rows in sql
SQL
0 vote244 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL