alter table sql oracle drop code example
Example 1: delete column from table oracle PL SQL
ALTER TABLE table_name DROP COLUMN column_name;
Example 2: PL SQL MODIFY COLUMN NME
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;
ALTER TABLE table_name DROP COLUMN column_name;
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;