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 vote187 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote244 views1 answer
Tsql cte in a transaction
SQL
0 vote213 views1 answer
Sql string contains case sensitive
SQL
0 vote199 views1 answer
Postgresql if else endif
SQL
0 vote191 views1 answer
SAP Return
SQL
3 votes208 views2 answers
Sqlite print all column names
SQL
0 vote281 views1 answer
Do you know sql
SQL
0 vote206 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote212 views2 answers
Insert data mysql with cmd
SQL
5 votes199 views2 answers
Oracle apex debug mode
SQL