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 vote290 views1 answer
Multiple row join
SQL
0 vote172 views1 answer
What does the -p flag do in mysql cli
SQL
11 votes160 views2 answers
How to import mysql database command line
SQL
0 vote152 views1 answer
Order by with where clause in mysql
SQL
0 vote150 views1 answer
Mysql update from n to 100
SQL
0 vote172 views2 answers
Uninstall postgresql mac
SQL
3 votes153 views3 answers
How to set up an auto incrementing id db browser
SQL
4 votes277 views1 answer
Oracle table statistics
SQL
3 votes148 views1 answer
Mysql set field unique
SQL
0 vote176 views1 answer
How to pass list as parameter in SQL query
SQL