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;

Source: grepper.com

Similar codes

0 vote118 views1 answer
Mssql last day of month
SQL
0 vote149 views1 answer
Order by number of character in sql
SQL
0 vote105 views2 answers
Many to many flask-sqlalchemy
SQL
6 votes109 views2 answers
Mysql get yesterday
SQL
0 vote106 views1 answer
Find invalid datetime field
SQL
0 vote102 views1 answer
Order by monthly in sql
SQL
1 vote198 views2 answers
Postgres select from last 3 months
SQL
5 votes101 views1 answer
Sql select ciunt
SQL
-1 vote105 views2 answers
Postgresql user permissions to database
SQL
0 vote115 views1 answer
How to print some string in mysql
SQL