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 vote154 views1 answer
Mysql workbench view
SQL
13 votes162 views3 answers
Insert mysql ifile nto database
SQL
1 vote146 views1 answer
Select statement to print longest name
SQL
0 vote175 views1 answer
Mysql date equals to current_date plus days
SQL
1 vote178 views1 answer
Mysql select all and rename one
SQL
0 vote177 views1 answer
Sql create table with references not primary key
SQL
1 vote164 views2 answers
Backup table mssql
SQL
8 votes161 views1 answer
How to check mysql version in xampp
SQL
0 vote159 views1 answer
Sql list dates between two dates
SQL
0 vote160 views1 answer
Sql check if column exists
SQL