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

0 vote280 views1 answer
Plsql check for string in numeric
SQL
0 vote285 views1 answer
Import Data in MySQL without using any other software
SQL
-1 vote245 views10 answers
Delete Query in SQL Server
SQL
2 votes298 views1 answer
Q operator in plsql
SQL
6 votes295 views2 answers
How to get yesterday date in mysql
SQL
1 vote284 views4 answers
Aggregate function in sql
SQL
3 votes278 views2 answers
How to load files in mysql
SQL
10 votes270 views4 answers
Fetch first 5 characters of the string in sql
SQL
4 votes280 views1 answer
Oracle session date format
SQL
6 votes314 views2 answers
Oracle trigger
SQL