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 vote206 views1 answer
Sqlite insert or update
SQL
7 votes205 views2 answers
Sql server drop temp table if exists
SQL
9 votes196 views4 answers
How to alter table column name in mysql
SQL
0 vote168 views2 answers
Delete the last item in a table sql
SQL
1 vote206 views1 answer
Psql show with user is logged in
SQL
1 vote212 views1 answer
Mysql find tables with column name
SQL
0 vote190 views1 answer
Grepper sql workbench download
SQL
0 vote158 views1 answer
Get last run query sql server
SQL
0 vote187 views1 answer
Mysql case when null
SQL
0 vote161 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL