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 vote193 views1 answer
Mysql command line ubuntu
SQL
0 vote196 views1 answer
Sql find table by name
SQL
0 vote277 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
1 vote179 views1 answer
Mysql check table exists
SQL
0 vote190 views4 answers
User defined function sql
SQL
0 vote181 views1 answer
Transaction database with php
SQL
1 vote191 views1 answer
Too many connections mysql
SQL
23 votes252 views2 answers
Query to delete a database in mysql
SQL
0 vote184 views1 answer
Sql replace id with name from another table
SQL
0 vote179 views1 answer
Join creating duplicate columns sqllite
SQL