alter statement in oracle code example
Example 1: alter table oracle
ALTER TABLE tablename MODIFY columnname varchar2(100)
Example 2: update table syntax in oracle
{
UPDATE table-Name [[AS] correlation-Name]
SET column-Name = Value
[ , column-Name = Value} ]*
[WHERE clause] |
UPDATE table-Name
SET column-Name = Value
[ , column-Name = Value ]*
WHERE CURRENT OF
}