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 vote170 views1 answer
Mysql count with two joins
SQL
1 vote184 views1 answer
Add current timestamp in mysql
SQL
1 vote179 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote164 views1 answer
Postgresql alter column nullable
SQL
25 votes272 views6 answers
Change column name mysql
SQL
0 vote176 views1 answer
How to add timestamp column in mysql
SQL
4 votes237 views1 answer
Postgresql list sequences
SQL
4 votes163 views2 answers
Postgres update single column
SQL
0 vote189 views1 answer
How to remove quotes from a string in ssis load file
SQL
2 votes156 views1 answer
Ifnull postgres
SQL