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 vote176 views1 answer
Select distinct after join
SQL
0 vote162 views2 answers
Update all linkedserver tables with openquery on db
SQL
1 vote166 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote206 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
18 votes168 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote180 views1 answer
Distance calculator from lat long sql query
SQL
0 vote155 views1 answer
If exist column in table drop sql query mysql
SQL
1 vote205 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote194 views2 answers
Create-toys-table-with-toy_name-column
SQL
2 votes194 views2 answers
Calculate percentage in sql
SQL