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

5 votes200 views4 answers
Restart the psql server windows
SQL
5 votes236 views1 answer
Oracle asynchronous procedure
SQL
1 vote155 views2 answers
Mysql update table from another table
SQL
0 vote159 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote135 views1 answer
Create table employees oracle
SQL
0 vote152 views2 answers
Connect to mysql server mac terminal
SQL
0 vote147 views1 answer
Désinstaller postgresql linux
SQL
0 vote163 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
2 votes145 views1 answer
How to find constraints on a table in oracle
SQL
11 votes187 views2 answers
Having keyword sql
SQL