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

7 votes242 views1 answer
Mysql unsafe update
SQL
0 vote252 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
11 votes276 views5 answers
Update table from another table mysql
SQL
0 vote244 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote260 views2 answers
Python mysql create table if not exists
SQL
0 vote296 views1 answer
Bitmap join index
SQL
0 vote289 views1 answer
Firebase sql
SQL
0 vote246 views1 answer
Generate sequence number in sql server
SQL
0 vote255 views2 answers
MySQL top percent
SQL
0 vote265 views1 answer
Mysql dump everythign
SQL