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

-1 vote331 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote368 views1 answer
Databricks install odbc driver connect to sql server
SQL
1 vote343 views1 answer
Create new table in SQL from old table with data
SQL
0 vote307 views1 answer
How to see the content of tables in pgadmin
SQL
10 votes456 views4 answers
Sql server pagination
SQL
0 vote352 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote348 views1 answer
Sql server change schema of a table
SQL
0 vote468 views1 answer
Sql developer export connections
SQL
0 vote373 views1 answer
Left join vs inner join performance
SQL
13 votes342 views5 answers
Sql default
SQL