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

21 votes190 views4 answers
Oracle add column
SQL
0 vote9.7K views1 answer
Postgresql delete type
SQL
0 vote189 views1 answer
Mysql pad zeros
SQL
12 votes184 views1 answer
Docker run mysql image
SQL
15 votes182 views5 answers
If null mysql
SQL
0 vote166 views1 answer
Sql beginning of previous month
SQL
2 votes180 views1 answer
Wait delay in sql server
SQL
1 vote174 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote272 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote253 views1 answer
Sql alter table add column if exists
SQL