How to modify the value of a field in oracle

In Oracle, you can use the update command to modify the value of the field. This command is used to update the data of the table. After the update statement is executed, it must be submitted by commit, otherwise it will only be valid in the current session. The syntax is " update table name set field = 'value' where condition".

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

How does oracle modify the value of a field

You need to use the update statement to modify it.

Basic syntax of the update statement:

update 表名 set 字段='值' where 条件;

For example, there is the following data in the test table:

Now we need to add the item with ID=3 To change the NAME of the data to badkano, you can use the following statement:

update test set NAME='badkano' where ID=3;
commit;

Result after execution:

Description:

After the update statement is executed , must be submitted by commit, otherwise it will only be valid in the current session.

Recommended tutorial: "Oracle Tutorial"

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