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

2 votes287 views2 answers
Enable foreign key checks postgres
SQL
5 votes286 views1 answer
Commentaire table oracle
SQL
0 vote301 views1 answer
Is not numeric sql
SQL
3 votes229 views2 answers
Mysql sum with condition
SQL
0 vote268 views1 answer
Get who is hired in specific month in sql
SQL
15 votes272 views2 answers
Open postgress in terminal mac
SQL
0 vote324 views1 answer
Sql to excel pgadmin
SQL
1 vote288 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
11 votes281 views2 answers
Turn off safe mode mysql
SQL
0 vote272 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL