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

16 votes164 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
3 votes181 views5 answers
Foreign keys
SQL
0 vote163 views1 answer
Oracle select partition
SQL
4 votes149 views1 answer
Mysql copy table with new name
SQL
2 votes167 views1 answer
How to show the whole table in sql
SQL
0 vote155 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
1 vote179 views1 answer
How not to sort by average rating
SQL
0 vote157 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote165 views1 answer
Insert ip address in mysql
SQL
0 vote154 views1 answer
Openquery insert into linked server
SQL