Oracle drop column

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;

Oracle alter table delete column

alter table table_name drop column column_name;
alter table table_name drop (column_name1, column_name2);

Source: oracle-base.com

Similar codes

2 votes92 views1 answer
Oracle run_duration average
SQL
0 vote131 views1 answer
Alter domain sql
SQL
1 vote108 views2 answers
Mysql update table from another table
SQL
0 vote118 views1 answer
On delete set default
SQL
0 vote101 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote102 views1 answer
How to check default value of column in sql server
SQL
0 vote120 views1 answer
Default password for mysql_secure_installation in mac
SQL
1 vote98 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
4 votes122 views1 answer
Is there any command to change postgres password
SQL
3 votes115 views3 answers
1396(hy00) mysql error
SQL