Breaking News: Grepper is joining You.com. Read the official announcement!

oracle sql drop column if exists

Add Answer

VasteMonde answered on March 19, 2021 Popularity 9/10 Helpfulness 4/10

answer oracle sql drop column if exists

related drop table if exists oracle

related oracle drop table if exists

oracle sql drop column if exists

Comment

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;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: exists oracle sql sql-drop

Link to this answer
Share Copy Link

Contributed on Mar 19 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

drop table if exists oracle

Comment

DECLARE
    existing_table number;
BEGIN
    SELECT count(*) into existing_table FROM ALL_TABLES
    WHERE TABLE_NAME = 'table_name' AND OWNER = 'owner';
    IF existing_table = 1 then
        EXECUTE IMMEDIATE 'DROP TABLE owner.table_name';
    END IF;
END;
/
CREATE TABLE owner.table_name (BDAY DATE, [...]);

Popularity 9/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: drop-table d

Link to this answer
Share Copy Link

Contributed on Aug 27 2021

VasteMonde

0 Answers Avg Quality 2/10

oracle drop table if exists

Comment

DECLARE
  table_exists NUMBER := 0;
BEGIN
  -- Check if the table exists
  SELECT COUNT(*) INTO table_exists
  FROM user_tables
  WHERE table_name = 'YOUR_TABLE_NAME';

  -- Drop the table if it exists
  IF table_exists > 0 THEN
    EXECUTE IMMEDIATE 'DROP TABLE YOUR_TABLE_NAME';
    DBMS_OUTPUT.PUT_LINE('Table dropped successfully.');
  ELSE
    DBMS_OUTPUT.PUT_LINE('Table does not exist.');
  END IF;
END;
/

Popularity 6/10 Helpfulness 3/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

oracle sql drop column if exists

Contents

More Related Answers

oracle sql drop column if exists

Closely Related Answers

drop table if exists oracle

oracle drop table if exists

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.