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 vote314 views3 answers
Between keyword sql
SQL
0 vote322 views1 answer
How to check xampp mysql password
SQL
0 vote345 views1 answer
Sql delimiter to columns
SQL
0 vote382 views1 answer
Mysql dump for selected row
SQL
2 votes325 views1 answer
Set boolean flasksql
SQL
1 vote328 views1 answer
Postgres get month name from date
SQL
0 vote329 views1 answer
Kill a pid redshift
SQL
0 vote285 views3 answers
Mysql calculate age from date of birth
SQL
1 vote331 views2 answers
Sql for date greater than
SQL
-1 vote321 views2 answers
Get day in sql
SQL