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 vote120 views1 answer
Connecting to my cloud sql server with c#
SQL
1 vote125 views1 answer
Psql autocomplete for mac brew install
SQL
17 votes136 views3 answers
How to change a collumn name in sql
SQL
1 vote116 views1 answer
Oracle explain plan
SQL
0 vote155 views1 answer
Add new column in sql with foreign key
SQL
4 votes127 views6 answers
Second max salary in sql
SQL
15 votes129 views3 answers
Mysql update add to existing value
SQL
0 vote114 views2 answers
Get top 1 row of each group
SQL
1 vote133 views1 answer
Delete from inner join sql
SQL
0 vote126 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL