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

-1 vote391 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote330 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote361 views1 answer
Test database for sql
SQL
0 vote341 views1 answer
Postgre admin slow
SQL
0 vote360 views1 answer
Postgres create extension if not exists
SQL
1 vote354 views1 answer
Where to locate set password for mysql
SQL
0 vote386 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote350 views1 answer
Query archive mode
SQL
1 vote370 views1 answer
Oracle previous year
SQL
1 vote344 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL