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

4 votes78 views1 answer
Oracle sleep
SQL
3 votes129 views1 answer
Mysql replace string in table
SQL
1 vote113 views1 answer
Mysql view command
SQL
1 vote132 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote172 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote148 views1 answer
Eliminate zero from integer mysql
SQL
0 vote117 views1 answer
Sql get user account
SQL
3 votes111 views2 answers
Sql paging query
SQL
2 votes155 views1 answer
Brew start postgres manual
SQL
7 votes117 views1 answer
Set sequence value oracle
SQL