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;

Similar codes

5 votes107 views1 answer
Copy table from one database to another mysql
SQL
2 votes147 views1 answer
Set boolean flasksql
SQL
1 vote207 views1 answer
Pgsql sum switch case
SQL
-1 vote104 views1 answer
Oracle db list usernames
SQL
0 vote147 views1 answer
Mysql find db contarint
SQL
0 vote161 views1 answer
Psql check if sql script is valid
SQL
0 vote169 views1 answer
How to get button for every record from mysql
SQL
0 vote255 views1 answer
How to get all values in a table mysql in c#
SQL
3 votes113 views1 answer
V$session not found in oracle
SQL
4 votes142 views1 answer
Sql group by year
SQL