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;

Source: grepper.com

Similar codes

0 vote138 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote137 views1 answer
Mysql workbench view
SQL
0 vote153 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote139 views1 answer
Postgresql on conflict pair
SQL
0 vote131 views1 answer
Oracle index hint multiple tables example
SQL
4 votes134 views1 answer
Datepart postgres
SQL
0 vote162 views1 answer
Mysql dump with table query
SQL
3 votes181 views1 answer
Dbms_scheduler drop_job
SQL
0 vote93 views1 answer
Mssql view column data type
SQL
1 vote162 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL