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 vote123 views1 answer
Postgresql show owner of database
SQL
0 vote115 views1 answer
Mysql grouping functions
SQL
6 votes142 views2 answers
Mysql convert timestamp to date
SQL
1 vote117 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote132 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote143 views1 answer
Mysql range of dates overlap
SQL
10 votes105 views3 answers
Insert into auto increment mysql
SQL
2 votes125 views2 answers
Postgres add column integer
SQL
0 vote131 views1 answer
Mysql get only the field names in a table
SQL
12 votes124 views2 answers
Delete all nodes neo4j
SQL