alter table alter column oracle code example
Example 1: delete column from table oracle PL SQL
ALTER TABLE table_name DROP COLUMN column_name;
Example 2: alter table column size oracle
ALTER TABLE tablename MODIFY fieldname VARCHAR2(100);
Example 3: alter table oracle
ALTER TABLE tablename MODIFY columnname varchar2(100)