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 votes255 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote260 views1 answer
Authentication modes in sql server
SQL
0 vote235 views1 answer
To change the database owner in SQL server
SQL
5 votes274 views2 answers
Functions
SQL
0 vote231 views1 answer
Add alternate add column sql
SQL
0 vote232 views1 answer
Permission denied postgres \copy csv command line
SQL
3 votes224 views2 answers
How to View column names of a table in SQL
SQL
0 vote265 views1 answer
Stored procedure function relation
SQL
7 votes240 views2 answers
Show size database mysql
SQL
1 vote242 views1 answer
Mysql query bulk insert
SQL