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 vote143 views1 answer
Joins vs includes
SQL
1 vote158 views1 answer
Limit offset order by mysql
SQL
5 votes154 views1 answer
Oracle sysdate - 1 month
SQL
0 vote162 views1 answer
Time data type in mysql
SQL
11 votes137 views1 answer
Mysql text type max length
SQL
0 vote139 views2 answers
Postgres show current role
SQL
0 vote151 views1 answer
Sql last 3 rows
SQL
0 vote135 views1 answer
Sql string contains case sensitive
SQL
0 vote141 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote129 views2 answers
Postgresql change user role grant
SQL