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

0 vote105 views2 answers
Return the number of records in a single table mysql
SQL
0 vote105 views1 answer
Sql delete from with relation
SQL
0 vote105 views1 answer
Sql express database size limit
SQL
10 votes126 views6 answers
Mysql set root password
SQL
0 vote187 views1 answer
How to use select union and loop
SQL
0 vote107 views1 answer
Sql alternative to max statement
SQL
0 vote104 views1 answer
Windows aggregate functions in postgresql
SQL
2 votes104 views1 answer
Rails execute sql
SQL
11 votes108 views2 answers
Mysql set safe mode off
SQL
2 votes124 views1 answer
Revokeprivileges mysql
SQL