update column oracle sql code example

Example 1: alter table oracle

ALTER TABLE tablename MODIFY columnname varchar2(100)

Example 2: oracle SQL update

UPDATE table
SET column1 = expression1,
    column2 = expression2,
    ...
    column_n = expression_n
[WHERE conditions];