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

2 votes236 views2 answers
How to view created temporary tables in mysql
SQL
0 vote248 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote233 views1 answer
Mysql select where field is a value
SQL
0 vote254 views1 answer
How to update date value in sql
SQL
9 votes243 views4 answers
SQL Date Format
SQL
0 vote225 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote265 views1 answer
Error code 1451 sql
SQL
1 vote230 views1 answer
Create sqlite database in laravel
SQL
0 vote238 views1 answer
Oracle show running job
SQL
0 vote241 views1 answer
Mysql grouping functions
SQL