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

8 votes221 views1 answer
Racle create auto increment column
SQL
0 vote203 views2 answers
Starts and end with vowel sql
SQL
0 vote173 views1 answer
Clear query cache sql server
SQL
0 vote175 views1 answer
What is the essence of SQL?
SQL
0 vote223 views1 answer
Replace \n sql
SQL
-1 vote200 views5 answers
Operator in sql
SQL
49 votes289 views6 answers
Mysql add column to table
SQL
0 vote396 views1 answer
Redirection 301 htaccess nom de domaine
SQL
3 votes257 views3 answers
List columns in table postgres
SQL
23 votes193 views4 answers
How to uninstall postgresql in ubuntu
SQL