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

0 vote137 views1 answer
Mysql max number not returning correct value
SQL
0 vote138 views1 answer
Create or replace view postgress
SQL
0 vote134 views1 answer
List all indexes postgres
SQL
3 votes133 views1 answer
Laravel database Using Named Bindings
SQL
92 votes350 views6 answers
Substring
SQL
0 vote134 views1 answer
T-sql update table variale
SQL
0 vote128 views3 answers
Postgresql grant alter table to user
SQL
0 vote143 views1 answer
Intellij idea add mysql connector
SQL
2 votes127 views1 answer
Sql create database
SQL
0 vote100 views1 answer
Mysql offset from bottom
SQL