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

2 votes177 views1 answer
Get hour from date sql
SQL
0 vote167 views1 answer
Json_remove mysql
SQL
0 vote261 views1 answer
Example database query
SQL
1 vote185 views1 answer
Sql row having max
SQL
1 vote175 views1 answer
Operator does not exist: integer = text
SQL
2 votes190 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote163 views1 answer
Mysql calculated column
SQL
0 vote280 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote204 views1 answer
How to find date from date table in sql
SQL
4 votes182 views1 answer
Create column mysql terminal
SQL