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 vote124 views1 answer
Mysql insert into select transaction c#
SQL
1 vote69 views1 answer
File /etc/init.d/mysql not exists
SQL
1 vote107 views1 answer
Cross schema query oracle 2 users
SQL
2 votes127 views1 answer
Oracle percentage
SQL
0 vote132 views1 answer
Insert or update sql firebird
SQL
-1 vote138 views4 answers
Full outer join in sql
SQL
0 vote130 views3 answers
Constraint sql
SQL
0 vote126 views1 answer
SAP Return
SQL
0 vote80 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote134 views1 answer
Mysql default tls v1.3 ciphersuites
SQL