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

13 votes181 views4 answers
Command line mysql import
SQL
17 votes164 views4 answers
Show tables sql server
SQL
0 vote173 views1 answer
Linked server delete openquery
SQL
0 vote191 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote160 views1 answer
Get records in sql according to month name and count
SQL
0 vote169 views1 answer
Postgres declare variable
SQL
0 vote165 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote157 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote167 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
3 votes171 views2 answers
Mysql config user password
SQL