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 vote128 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote121 views1 answer
Check index sql server
SQL
0 vote125 views1 answer
Mysql select distinct date from timestamp
SQL
5 votes134 views2 answers
Oracle show procedures
SQL
0 vote121 views1 answer
Create a table from one field of another table
SQL
0 vote84 views1 answer
How to check oracle index table
SQL
0 vote121 views3 answers
Postgresql grant alter table to user
SQL
0 vote132 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
1 vote126 views1 answer
Sql pick random row
SQL
1 vote121 views1 answer
Cross schema query oracle 2 users
SQL