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 votes368 views6 answers
Mysql find duplicates in same table
SQL
5 votes369 views2 answers
Functions
SQL
41 votes427 views6 answers
Alter table add column in SQL Server
SQL
3 votes331 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
-2 votes345 views2 answers
Union all in sql
SQL
0 vote372 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote346 views1 answer
Oracle select partition
SQL
10 votes322 views2 answers
Reset mysql root password mac
SQL
4 votes291 views1 answer
Sql list users and roles
SQL
1 vote344 views1 answer
How to subtract from the value of a table in sql
SQL