oracle sql ALTER TABLE rename and add code example
Example 1: add column table pl sql
ALTER TABLE table_name
ADD column_name column_definition;
Example 2: PL SQL MODIFY COLUMN NME
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;
ALTER TABLE table_name
ADD column_name column_definition;
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;