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

1 vote331 views1 answer
Truncate left characters mysql
SQL
3 votes353 views2 answers
Oracle apex charging debug
SQL
-1 vote342 views1 answer
Su: Authentication failure mysql
SQL
0 vote354 views1 answer
Sql composite key
SQL
0 vote381 views1 answer
How to fetch data from database in sql
SQL
0 vote406 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote334 views1 answer
Low level operator in dbms
SQL
0 vote341 views1 answer
RowDataPacket
SQL
6 votes338 views2 answers
Return columns from table sql
SQL
0 vote342 views1 answer
Console output pl sql
SQL