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 vote304 views1 answer
Proc sql not in working
SQL
4 votes301 views2 answers
Installing sql on ubuntu
SQL
0 vote299 views1 answer
Write a query to peint the pattern P(20)
SQL
4 votes275 views1 answer
Sql data types
SQL
2 votes292 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
38 votes336 views6 answers
Alter table mysql
SQL
6 votes277 views3 answers
Mysql first day of year
SQL
3 votes301 views1 answer
Oracle drop user
SQL
1 vote277 views1 answer
Return size of tables in mysql
SQL
6 votes270 views1 answer
Rank function in oracle with example
SQL