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 vote176 views1 answer
Compare strings lexicographically in sql
SQL
1 vote119 views1 answer
Oracle compile schema
SQL
4 votes143 views3 answers
How to describe a table in sqlite3
SQL
0 vote145 views1 answer
Mysql master slave setup with keepalived
SQL
1 vote157 views1 answer
Delete dublicate rows sql
SQL
0 vote128 views1 answer
Tsql generate rows
SQL
0 vote182 views1 answer
Kimball data warehouse sql calendar
SQL
7 votes150 views2 answers
Phpmyadmin change password
SQL
8 votes133 views1 answer
Today minus 15 days postgresql
SQL
1 vote141 views1 answer
Postgres get timestamp
SQL