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

38 votes212 views6 answers
Alter table mysql
SQL
29 votes150 views5 answers
Mysql show table structure
SQL
1 vote162 views1 answer
Mysql size int
SQL
2 votes161 views1 answer
Mysql application.properties spring boot
SQL
0 vote165 views1 answer
Plsql find location of procedure
SQL
0 vote152 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote161 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote147 views1 answer
Sql inserted
SQL
4 votes161 views1 answer
Oracle user tables
SQL
7 votes155 views2 answers
What is sql clause
SQL