Oracle中delete和update语法

delete删除表中某行数据

语法格式：

delete [from] table_name [where condition]

例如：删除user表中的userId为’01’的数据：

delete from user where userId = '01'

update更新表中某行数据

语法格式：

update table_name set column_name = 'value'
where column_name2 = ' '[conditions]

例如：

update user set user_name = 'zhangsan'
where userId = '01'