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;

Similar codes

16 votes384 views1 answer
Mysql mediumint max value
SQL
2 votes327 views4 answers
Duplicate record mysql
SQL
0 vote331 views1 answer
Database xml sql
SQL
0 vote345 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote323 views1 answer
Oracle sql drop table
SQL
0 vote335 views1 answer
Oracle list partitions
SQL
0 vote326 views1 answer
Order by with where clause in mysql
SQL
0 vote365 views2 answers
How to drop mili second in sql
SQL
0 vote314 views1 answer
Uncomment listen_address=localhost
SQL
0 vote303 views1 answer
Selects all the columns from the sailors table
SQL