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 vote182 views1 answer
Find largest table in mysql database
SQL
2 votes183 views2 answers
Postgresql date at timezone
SQL
1 vote186 views1 answer
Copy postgres table from one schema into another
SQL
0 vote199 views1 answer
Sql recherche nom prenom
SQL
0 vote214 views2 answers
How do I install microsoft SQL on my Mac?
SQL
5 votes202 views2 answers
Get number of columns sql
SQL
2 votes198 views2 answers
Mysql get time from datetime
SQL
0 vote198 views1 answer
Change date format in oracle query
SQL
5 votes198 views2 answers
Oracle to_timestamp
SQL
1 vote180 views1 answer
Login to database mysql terminal
SQL