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 vote277 views1 answer
Sqlite insert or update
SQL
0 vote261 views1 answer
Oracle show running job
SQL
0 vote272 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
2 votes272 views1 answer
Mysql select default if null
SQL
0 vote250 views1 answer
Insufficient memory to excute the sql query
SQL
4 votes298 views4 answers
Mysql get date from datetime
SQL
0 vote257 views1 answer
Sql_inner_join
SQL
0 vote250 views1 answer
Check if table exists oracle
SQL
12 votes257 views10 answers
Google
SQL
1 vote292 views1 answer
UseSqlServer no definition
SQL