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 vote177 views1 answer
SQL Server modify_timestamp trigger
SQL
2 votes178 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote188 views1 answer
Mysql month name extract
SQL
9 votes186 views4 answers
How to alter table column name in mysql
SQL
0 vote181 views1 answer
Normalization in database 2nd normal form
SQL
0 vote185 views1 answer
Linked server delete openquery
SQL
1 vote218 views1 answer
Psql view enum values
SQL
0 vote195 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote143 views1 answer
Oracle list all stored procedures
SQL
0 vote174 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL