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 vote229 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote146 views1 answer
Oracle sql replace string in clob
SQL
1 vote212 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote204 views1 answer
Mysql Like(searching in the string)
SQL
2 votes190 views1 answer
Pandas to sql index
SQL
0 vote201 views1 answer
Mysql set boolean default value
SQL
3 votes201 views1 answer
Unsigned int in mysql
SQL
0 vote319 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote173 views1 answer
SQL server select to get sum of hours
SQL
0 vote182 views1 answer
Postgresql array to rows
SQL