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 vote128 views4 answers
User defined function sql
SQL
5 votes159 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
6 votes127 views2 answers
Mysql convert timestamp to date
SQL
7 votes143 views2 answers
Where keyword sql
SQL
0 vote131 views1 answer
Flush user resource mysql
SQL
0 vote155 views1 answer
Split first name and last name in sql
SQL
5 votes145 views1 answer
Oracle sysdate - 1 month
SQL
3 votes132 views2 answers
Mysql HAVING
SQL
1 vote138 views1 answer
Decalre temp table sql
SQL
0 vote137 views1 answer
Create table split string function in sql server
SQL