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 vote156 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote161 views1 answer
Search In the Data using ObjectName
SQL
0 vote189 views1 answer
Sql count matching group by
SQL
17 votes145 views4 answers
Sort by mysql
SQL
2 votes156 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
5 votes170 views1 answer
Oracle create table comment
SQL
9 votes150 views1 answer
Oracle get table schema
SQL
-1 vote160 views1 answer
Mysql change database charset and collation
SQL
0 vote161 views1 answer
Sql sum show 0 result
SQL
1 vote151 views1 answer
Md5 encryption for existing records
SQL