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

18 votes233 views3 answers
Mysql number format
SQL
0 vote243 views1 answer
Migration graphql
SQL
10 votes197 views2 answers
Sql where clause multiple values
SQL
-1 vote231 views1 answer
Search all database tables for a value sqlserver
SQL
4 votes236 views1 answer
Mysql copy table with new name
SQL
0 vote217 views1 answer
Check if table exists oracle
SQL
0 vote237 views1 answer
Pl/pgsql declare variable
SQL
2 votes225 views1 answer
Query to find table size in oracle 12c
SQL
9 votes260 views3 answers
Postgres make sql dump
SQL
0 vote275 views1 answer
Sql doesn't contain
SQL