delete column from table oracle PL SQL

SteDeus answered on March 13, 2020 Popularity 10/10 Helpfulness 7/10

answer delete column from table oracle PL SQL

related oracle drop column

delete column from table oracle PL SQL

Comment

ALTER TABLE table_name DROP COLUMN column_name;

Popularity 10/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: oracle sql

Link to this answer
Share Copy Link

Contributed on Mar 13 2020

SteDeus

0 Answers Avg Quality 2/10

Closely Related Answers

oracle drop column

Comment

ALTER TABLE my_table DROP COLUMN my_col;
-- To check if column exists before renaming it:
DECLARE
    l_cnt INTEGER;
BEGIN
    SELECT count(*) INTO l_cnt
    FROM dba_tab_columns		-- or all_tab_columns (depending on grants)
    WHERE owner = 'my_schema' AND table_name = 'my_table' 
    	AND column_name = 'my_col';
    IF (l_cnt = 1) THEN
        EXECUTE IMMEDIATE 'ALTER TABLE my_schema.my_table DROP COLUMN my_col';
    END IF;
END;

Popularity 10/10 Helpfulness 9/10 Language sql

Source: Grepper

Tags: drop

Link to this answer
Share Copy Link

Contributed on May 04 2021

VasteMonde

0 Answers Avg Quality 2/10

delete column from table oracle PL SQL

Contents

More Related Answers

delete column from table oracle PL SQL

Closely Related Answers

oracle drop column

Grepper

Documentation

Social

Legal

Contact

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