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 vote133 views1 answer
T sql less than date
SQL
6 votes131 views2 answers
Mysql execute file
SQL
0 vote123 views1 answer
Flask sqlalchemy update row
SQL
6 votes167 views3 answers
Mysql change auto_increment start value
SQL
17 votes121 views4 answers
Show tables sql server
SQL
1 vote277 views2 answers
Sql unique rows
SQL
1 vote123 views1 answer
Postgres check for foreign key
SQL
15 votes128 views4 answers
Mysql where value is null
SQL
0 vote132 views1 answer
Sql server select top 2 of each group
SQL
0 vote125 views1 answer
Mysql connection with sqlalchecmy
SQL