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 vote226 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote208 views1 answer
Sql column contains special character
SQL
1 vote176 views1 answer
Sql server 2016 reseed identity
SQL
0 vote220 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote188 views1 answer
Java spring boot connect to sql server
SQL
2 votes224 views1 answer
Removing view
SQL
1 vote201 views1 answer
Postgresql convert text to float
SQL
10 votes205 views4 answers
Primary key sql
SQL
1 vote205 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote213 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL