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 vote185 views1 answer
Mysql exception output
SQL
0 vote157 views1 answer
Oracle execute package dblink
SQL
10 votes172 views3 answers
Join multiple tables sql
SQL
11 votes162 views1 answer
How to get ddl for materialized view
SQL
5 votes160 views3 answers
Mysql update field from one table to another
SQL
0 vote140 views1 answer
Big query add table rows to another table
SQL
50 votes195 views6 answers
Install mysql on ubuntu
SQL
0 vote178 views1 answer
Mysql order by where condition sub query
SQL
0 vote188 views1 answer
Updating database in sql
SQL
2 votes166 views1 answer
How to create sql database
SQL