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

3 votes276 views3 answers
Create a view postgres
SQL
0 vote267 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote285 views1 answer
Psql store procedure-return multiple table values
SQL
2 votes279 views3 answers
Mysql pass command from command line
SQL
3 votes289 views2 answers
How to open postgresql in windows
SQL
0 vote276 views1 answer
ORACLE PARSE STRING
SQL
0 vote267 views1 answer
Hw to delete a procedure in pl sql
SQL
3 votes258 views1 answer
Delete all content in table mysql
SQL
0 vote293 views1 answer
Postgresql create table many-to-many
SQL
1 vote272 views1 answer
Mysql select another database
SQL