How to modify table values ​​in oracle

In Oracle, you can use the Update statement to modify the values ​​in the table. This statement is used to modify the data in the table. The syntax is "UPDATE table name SET column name = new value WHERE column name = condition value".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How oracle modifies the value of the table

Command update set: Modify the data in the table

The update set command is used to modify the data in the table.

update set command format:

update 表名 set 字段=新值,… where 条件;

Common operations for data in Oracle database tables

Query all data in the table

select * from 表名; 例:select * from stu;

Modify the data in the table while querying

The

select * from 表名  for update;

Update statement is used to modify the data in the table.

Grammar:

UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值

1 Modify the data in the table: UPDATE statement:

Grammar:

UPDTAE table_name
SET column1 = value1,...
[WHERE conditions]

Recommended tutorial: "Oracle Video Tutorial 》

The above is the detailed content of How to modify table values ​​in oracle. For more information, please follow other related articles on the PHP Chinese website!