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 votes175 views2 answers
Oracle ddl
SQL
1 vote169 views2 answers
Replace text in sql
SQL
0 vote173 views1 answer
Max mysql
SQL
3 votes162 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote174 views2 answers
Regex starts with
SQL
0 vote151 views1 answer
Get number of table colums in sql query
SQL
0 vote161 views1 answer
Sql if else in select
SQL
1 vote198 views1 answer
Show databases mysql docker
SQL
14 votes196 views3 answers
Oracle sql limit results
SQL
0 vote175 views1 answer
Sqlite update only if greater
SQL