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 vote141 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote103 views1 answer
Login phpmyadmin without password
SQL
0 vote136 views3 answers
Join
SQL
0 vote101 views1 answer
SQL division of an integer by another integer get float CAST
SQL
8 votes121 views2 answers
Sqlsrv default port
SQL
0 vote109 views1 answer
INSERT INTO table using OpenQuery
SQL
2 votes114 views1 answer
Mysql select random id from table
SQL
37 votes118 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
1 vote113 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote100 views1 answer
Java spring boot connect to sql server
SQL